MX Release 3.2 (H06.25+, J06.14+)

For more information, see the concatenation operator in the SQL/MX Release 3.x Reference

Manual.

To terminate an SQL statement that spans multiple lines, use the SQL terminator for the session. A

syntax error is returned, if more than one SQL statement is included in the same line. For more

information, see “Setting and showing the SQL terminator” (page 57).

Case sensitivity

In the RMXCI interface, you can enter SQL statements and RMXCI interface commands in uppercase,

lowercase, or mixed-case characters. Command or statement parts, which you enclose in single

quotes (') or double quotes (“) are case sensitive. All other parts of statements and commands are

case-insensitive.

Using RMXCI commands

The RMXCI commands enable you to customize the SQL/MX Remote Conversational Interface (for

example, by using set commands) or return information about the interface settings or database

objects (for example, by using show commands):

• “Showing the session attributes” (page 55)

• “Setting and showing the idletimeout value for the session” (page 56)

• “Customizing the standard prompt” (page 56)

• “Setting and showing the SQL terminator” (page 57)

• “Displaying the elapsed time” (page 57)

• “Setting and showing the current schema” (page 58)

• “Limiting the result set of a query” (page 58)

• “Showing information about SQL database objects” (page 59)

• “Displaying run commands” (page 60)

• “Editing and rerun a command” (page 60)

• “Clearing the interface window” (page 60)

• “Obtaining help” (page 61)

For more information about the RMXCI commands, see Appendix A (page 76).

NOTE: Each RMXCI command must be entered in one line. Enter the SQL terminator, and then

re-enter the command in one line if you break a RMXCI command across more than one line.

Showing the session attributes

To display the attributes and settings of the current RMXCI session, use the env, show session

or session command. For example, the following session command displays the session

attributes:

Using RMXCI commands 55