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

Obtaining help

To display help text for a command that is supported in RMXCI, run the help command. For

example, the following command displays syntax and examples for the fc command:

SQL>help fc

For more information, see the “HELP command” (page 68).

Running SQL statements

In RMXCI, you can run SQL statements interactively. For a list of these statements, see Appendix B

(page 119).

This subsection shows examples of:

• “Executing an SQL Statement” (page 40)

• “Repeating an SQL Statement” (page 40)

• “Preparing and executing SQL Statements” (page 41)

• “Executing CREATE TRIGGER statements” (page 44)

To run SQL statements from script files in RMXCI, see Chapter 5 (page 48).

Executing an SQL Statement

You can query the employee table, and return an employee’s salary by executing the following

SELECT statement in RMXCI:

SQL>select salary from persnl.employee where jobcode=100;

SALARY

----------

175500.00

137000.10

139400.00

138000.40

75000.00

90000.00

118000.00

80000.00

70000.00

90000.00

56000.00

--- 11 row(s) selected.

If the SQL statement completes successfully, RMXCI returns a success message, followed by the

standard prompt. If a problem occurs during the execution of the SQL statement, RMXCI returns

an error message. For information about error messages, see the “Error messages” (page 121).

Repeating an SQL Statement

To run a previously run SQL statement, use the /,run or repeat command, for example:

40 Interactively running commands in RMXCI