SQL/MX Remote Conversational Interface (RMXCI) Guide for SQL/MX Release 3.2 (H06.25+, J06.14+)

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 in one line.
• Do not include SQL or RMXCI reserved word as an SQL terminator.
• If you run this command from 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
• The following command sets the SQL terminator to a period (.):
SQL>set sqlterminator .
• The following command sets the SQL terminator to a word, go:
SQL>set sqlterminator go
The following query ends with the new terminator, go:
SQL>select * from persnl.employee go
• The following command resets the SQL terminator to the default:
SQL>set sqlterminator ;
For more information, see “Setting and showing the SQL terminator” (page 57).
SET STATISTICS command
The set statistics command automatically retrieves the statistics information for an SQL
statement being run. The results returned are the same as results from get statistics command.
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 in one line.
Examples
This command shows the default output format as PERTABLE:
SQL>set statistics on
SQL>select * from job;
JOBCODE JOBDESC
------- ------------------
100 MANAGER
1234
450 PROGRAMMER
900 SECRETARY
300 SALESREP
500 ACCOUNTANT
400 SYSTEM ANALYST
250 ASSEMBLER
SET STATISTICS command 119