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

SQL>help

• The following command lists all the set commands:

SQL>help set

• The following command shows help text for set idletimeout:

SQL>help set idletimeout

HISTORY command

The history command displays the recently run commands, identifying each command by a

number that you can use to rerun or edit the command.

Syntax

HISTORY [number]

number

is the number of commands to display. The default number is 10. The maximum number is

100.

Considerations

• You must enter the command in one line.

• You can use the fc command to edit and rerun a command in the history buffer, or use the

repeat command to rerun a command without modifying it. See the “FC command” (page 86)

or the “REPEAT command” (page 102).

Example

Display the three most recent commands and use fc to display the fourteenth one:

SQL>history 3

14> set schema sales;

15> show tables

16> show views

SQL>fc 14

SQL>set schema sales

....

Now you can use the edit capabilities of fc to modify and run a different set schema statement.

IF...THEN command

IF...THEN statements allow for the conditional execution of actions. If the condition is met, the

action is taken; otherwise, no action is taken.

Syntax

IF {condition} THEN {action} {SQL-terminator}

Condition Parameter

The condition parameter (condition) is a Boolean statement structured as follows:

{variable-name|value}{operator}{variable-name|value}

HISTORY command 91