Neoview Script Guide (R2.2)

• This command starts the logging process and clears existing information from the log file
before logging new information to the file:
SQL>log persnl_ddl.log clear
• This command stops the logging process:
SQL>log off
For more information, see “Logging Output” (page 68).
MODE Command
The MODE command determines the operating mode of the current session to be either SQL for
database commands or CS for connectivity service commands. The default mode for Neoview
Script sessions is SQL.
Syntax
MODE { SQL | CS }
SQL
specifies SQL mode and supports the use of all SQL statements and Neoview Script interface
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 141).
CS mode also supports these Neoview Script interface 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
• MODE and SHOW MODE
• RESET LASTERROR and SHOW LASTERROR
• SET COLSEP and SHOW COLSEP
• SET HISTOPT and SHOW HISTOPT
• SET IDLETIMEOUT and SHOW IDLETIMEOUT
• SET MARKUP and SHOW MARKUP
• SET PROMPT
• SET TIME and SHOW TIME
• SET TIMING and SHOW TIMING
• VERSION
All other interface commands are disallowed in CS mode.
Considerations
• In the Neoview Script interface, you must enter the command on one line. The command
does not require an SQL terminator.
• You cannot execute the MODE command or any connectivity service commands in PRUN
script files. However, you can execute the MODE command in OBEY or @ script files.
MODE Command 97