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

4 Interactively running commands in RMXCI

After launching the HP NonStop SQL/MX Remote Conversational Interface, you can run SQL

statements and RMXCI commands in the interface.

• “Running commands” (page 33)

• “Using RMXCI commands” (page 34)

• “Running SQL statements” (page 40)

• “Logging output” (page 45)

Running commands

• “Product banner” (page 33)

• “Interface prompts” (page 33)

• “Breaking the command line” (page 33)

• “Case sensitivity” (page 34)

Product banner

After you launch RMXCI and connect to the database, the product banner appears in the RMXCI

interface. The product banner displays the data source to which you are connected, as shown:

Welcome to the NonStop(TM) SQL/MX Remote Conversational Interface

Connected to DataSource: TDM_Default_DataSource

SQL>

Interface prompts

During a session, RMXCI prompts you to enter SQL statements and RMXCI commands:

Standard prompt in SQL mode. You can change the standard prompt SQL> by using the

setsqlprompt command. For more information, see “Customizing the standard prompt”

(page 35).

SQL>

Continuation prompt. Continue the SQL statement from the previous line. Use the SQL

terminator (a semicolon by default) to terminate an SQL statement. For more information,

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

NOTE: RMXCI commands must be entered in one line and do not require an SQL

terminator.

Breaking the command line

You cannot break a RMXCI command over multiple lines. 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.

You can continue any SQL statement over multiple lines, breaking that statement at any point except

within a word, a numeric literal or a multi-character operator (for example, <=). To break a string

literal in a DML statement, use a concatenation operator ||.

For example, you can use the concatenation operator as follows:

SQL>select * from t where ch1 = 'abcdefg' ||

+> 'jk';

where ch1 is a char(10) column of table t.

Running commands 33