Skip to Content

A point to be noted while using queries in SQLCLI

Sometime time back I faced a problem when I was using the queries in SQLCLI. Every time I executed a query the result set was not displayed, rather an error message ‘more’ is not recognized as an internal or external command, operable program or batch file was displayed. I thought that it was due to some problem with the SQLCLI console but it was due to some other reason. The reason was the operating system’s paging settings. There is a command called MORE which helps in displaying one screen of output at a time in command line consoles.

If your system cannot call the MORE command then probably you will not be able to get the results for the query even if your query is correct.

image

This can be corrected by calling the SQLCLI from the root directory of the operating system [Windows in this case given below] as shown below.

image

Click the below links to learn more about the MORE command
Windows Platform
Unix and Linux Platform

Hope this will help you save time when you come across a similar situation. SQLCLI error.

To report this post you need to login first.

Be the first to leave a comment

You must be Logged on to comment or reply to a post.

Leave a Reply