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

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.

password

specifies the password of the user to log in to the database platform. If the password is not

specified, RMXCI prompts for the password.

hostname

specifies the host name or IP address of the database platform for the client connection. If the

hostname is not specified, the value is automatically used from the current RMXCI session. For

specifying a port other than the default 18650, add : port number to hostname. If RMXCI

was invoked with the -noconnect launch parameter, RMXCI prompts for hostname value.

dsnName

specifies the name of a data source. If the dsnName is not specified, the value is automatically

used from the current RMXCI session. If RMXCI was invoked with the -noconnect launch

parameter, RMXCI prompts for dsnName value.

CLEAR command 59