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

SQL> LABEL insertBob

SQL> INSERT INTO Employees(SSN, FName, LName) VALUES(123456789, 'Bob', 'Smith');

SQL> EXIT

LABEL command

The label command marks a point in the command history that you can jump to by using the

goto command. For more information, see the “GOTO command” (page 67).

Syntax

LABEL {label}

label

is a string of characters without quotes and spaces, or a quoted string.

Considerations

You must enter the command in one line.

Examples

The following command creates a label using a string of characters:

SQL>LABEL MyNewLabel

The following command creates a label using a quoted string:

SQL>LABEL "SQLMX Label"

LOCALHOST command

The localhost command allows you to run client system commands.

Syntax

LOCALHOST | LH <client m/c commands>

Considerations

• You must enter the command in one line.

• The localhost command has two limitations. When input is entered for the operating system

commands (for example, date, time, ls), the input is not visible until you press the Enter

key and cd command is not supported.

• If the set timing is set to on, the elapsed time information appears.

Examples

• Enter the localhost ls command to display the contents of the folder.

SQL>localhost ls

rmxci-perl.pl

rmxci-python.py

rmxci.cmd

rmxci.pl

rmxci.py

rmxci.sh

SQL> LH mkdir /usr/home/rmxci -> Will create a directory /usr/home/rmxci

• The following command displays the elapsed time information because the set timing

command is set to on:

LABEL command 71