Neoview Command Interface (NCI) Guide (R2.3)

--- 10 row(s) selected
• This command start the logging process, clears existing information from the log file, specifies
that no output appears on the console window, and the quiet option is enabled:
SQL>log c:\temp\b.txt clear, cmdtext off, quiet
SQL>select *
+>from neo.toi.job;
SQL> log off
Output of c:\temp\b.txt
====================
JOBCODE JOBDESC
------- ------------------
100 MANAGER
450 PROGRAMMER
900 SECRETARY
300 SALESREP
500 ACCOUNTANT
400 SYSTEM ANALYST
250 ASSEMBLER
420 ENGINEER
600 ADMINISTRATOR
200 PRODUCTION SUPV
--- 10 row(s) selected
This command stops the logging process:
SQL>log off
For more information, see “Logging Output” (page 73).
MODE Command
The MODE command determines the operating mode of the current session to be either SQL for
database commands, CS for connectivity service commands, or NS for Neoview service commands.
The default mode for NCI sessions is SQL.
Syntax
MODE { SQL | CS | NS }
SQL
specifies SQL mode and supports the use of all SQL statements and NCI commands. The
connectivity service commands are disallowed in SQL mode.
CS
specifies connectivity service (CS) mode and supports the use of connectivity service
commands. For more information, see Appendix C (page 157).
CS mode also supports these NCI commands:
• @ and OBEY
• CLEAR
• CONNECT, RECONNECT, DISCONNECT, EXIT, and QUIT
• ENV, SESSION, and SHOW SESSION
• FC and REPEAT
• HELP
• HISTORY and SAVEHIST
• LOG and SPOOL
106 NCI Commands