MX Release 3.1 (H06.23+, J06.12+)

SET SQLTERMINATOR command

The set sqlterminator command sets the SQL statement terminator for the current RMXCI

session. The default is a semicolon (;).

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 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 36).

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.

96 RMXCI commands