SQLCLI error

[Former Member]

When i execute a select query i am getting the following message.

sqlcli kathir=> select * from employee

'more' is not recognized as an internal or external command,

operable program or batch file.

8 rows selected (2 msec)

Can anyone tell how to correct this to get the values in the console.

[Former Member · Accepted solution]

I tried to call more.. it is not displaying anything and rather it is just in idle state for long time.

C:\WINNT\system32>more

and it is not giving any result.

[former_member185699 · Accepted solution]

Yes that's okay. If you start more from the command line you are in an interactive mode. You can leave more with the command 'q'. For details about more see 'more /?'.

So, the tool 'more' seems to work proper in your current environment. But can you run more in this cases where sqlcli give you the error "'more' is not recognized as an internal or external command"?

Please note, that more is part of the operating system and not part of sqlcli. Sqlcli only uses more for the output of results. So accessing the tool 'more' in your special environment seems to be the problem.

best regards,

Marco

[Former Member]

Hi Marco,

You really helped me a lot to solve the problem. I got it corrected and it was due to my system settings. Thanks a lot for your help.

Cheers,

Kathir.....

[Former Member]

Can you please tell me the default pager for SQLCLI?

At times it is working and some times it is not working.

Further i cannot find the Pager variable in the System.

[former_member185699]

The default pager is 'more' also on windows. On linux/unix you can also use 'less' etc.

Plese try to call 'more' from the command line to see if it works on your system.

best regards,

Marco

[Former Member]

That was useful...

Thanks Marco

[former_member185699]

Hi,

sqlcli uses a pager program like 'more' for the output of a result. Normally every operating system including windows supports 'more' as pager. Please check your system configuration. But you can also customize sqlcli to use your favorite pager. You can do this by setting the environment variable PAGER=<your favorite pager> before starting sqlcli.

regards,

Marco