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

SQL> EXIT

SQL> LABEL insertAlice

SQL> INSERT INTO Employees(SSN, FName, LName) VALUES(987654321, 'Alice', 'Smith');

SQL> EXIT

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 list that you can jump to by using the goto

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

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

LABEL command 93