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

Syntax
SET SQLTERMINATOR string
string
is a string value for the SQL terminator. The string may contain any characters except spaces.
Spaces are disallowed even if you enclose the string in double quotes. Lowercase and
uppercase characters are accepted, but the SQL terminator is always shown in uppercase.
Considerations
• You must enter the command on one line. The command does not require an SQL terminator.
• You can execute this command only in SQL mode.
• Do not include SQL or NCI reserved word as an SQL terminator.
• If you execute this command in a script file, it affects not only the SQL statements in the
script file but all subsequent SQL statements that are run in the current session. If you set
the SQL terminator in a script file, reset the default terminator at the end of the script file.
• To reset the default SQL terminator (;), enter this command:
SET SQLTERMINATOR ;
Examples
• This command sets the SQL terminator to a period (.):
SQL>set sqlterminator .
• This command sets the SQL terminator to a word, go:
SQL>set sqlterminator go
This query ends with the new terminator, go:
SQL>select * from persnl.employee go
• To reset the SQL terminator to the default, enter this command:
SQL>set sqlterminator ;
For more information, see “Setting and Showing the SQL Terminator” (page 64).
SET STATISTICS Command
The SET STATISTICS command automatically retrieves the statistics information for a query
being executed. The results returned are the same as would have been returned if the GET
STATISTICS command was executed. The default is OFF which means the statistics information
is not automatically printed for any queries.
Syntax
SET STATISTICS {ON | OFF}
Considerations
• You must enter the command on one line.
• You can execute this command in SQL mode only.
Examples
This command shows the default output format as PERTABLE:
SQL>set statistics on
SQL>select * from job;
SET STATISTICS Command 129