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

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

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 34)

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

• “Customizing the standard prompt” (page 35)

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

• “Displaying the elapsed time” (page 36)

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

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

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

• “Displaying run commands” (page 39)

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

• “Clearing the interface window” (page 39)

• “Obtaining help” (page 40)

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

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:

34 Interactively running commands in RMXCI