Neoview Command Interface (NCI) Guide (R2.4)

Example
Display the three most recent commands and use FC to redisplay 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 execute 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 executed; 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}
variable-name
is one of:
{LASTERROR|RECCOUNT|ACTIVITYCOUNT|ERRORCODE|[%]any ENV variable|any SQL parameter}
value
is any integer or a quoted string, where the quoted string is any non-quote character. \ is the
optional escape character.
operator
is one of:
MeaningOperator
equal to
== | =
not equal to
<> | != | ~= | ^=
greater than
>
greater than or equal to
>=
less than
<
less than or equal to
<=
Action Parameter
The action parameter (action) is any NCI or Neoview SQL command.
102 NCI Commands