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

rmxci-python.py

rmxci.pl

rmxci.py

settings.pl

settings.py

The following command creates an alias named .GOTO for the goto command:

SQL>alias .GOTO AS GOTO;

SQL> .GOTO mylabel

GOTO statement executed, ignoring all commands until a 'LABEL MYLABEL'

command is encountered.

The following command creates an alias named USE to perform the set schema operation, uses

the alias to set the schema to MX.USR, and checks the current schema to verify that the alias works

correctly:

SQL>alias use as "SET SCHEMA";

SQL>use MX.USR;

SQL>show schema

SCHEMA USR

CLEAR command

The clear command clears the interface window so that only the prompt appears at the top of

the window. This command does not clear the log file or reset the settings of the session.

Syntax

CLEAR

Considerations

You must enter the command in one line.

Example

The following command clears the interface window:

SQL>CLEAR

After this command runs, the interface window shows only the prompt:

SQL>

CONNECT command

The connect command creates a new connection to the database platform from the current or

existing RMXCI session.

Syntax

CONNECT [username [/password][@hostname][,dsnName]]

username

specifies the user name to log in to the database platform. If the user name is not specified,

RMXCI prompts for the user name.

CLEAR command 81