NonStop SQL/MP Reference Manual

NonStop SQL/MP Reference Manual—142115
E-14
EXIT Command
EXIT Command
EXIT is an SQLCI command that ends an SQLCI session. Pressing control-Y is the
same as typing EXIT.
Control returns to the process from which you started SQLCI, usually the command
interpreter.
If a user-defined transaction is in progress, SQLCI prompts you to specify whether you
want to commit or roll back the transaction.
Examples—EXIT
•
In the following example, the EXIT command is abbreviated to E:
>> E
End of SQLCI session
EXPLAIN Directive
EXPLAIN is a directive or SQL utility that describes the execution plans for queries.
You can execute EXPLAIN through SQLCI (as described here) or by using an option on
the SQLCOMP command line (as described in the NonStop SQL/MP programming
manual for your host language).
PLAN FOR
is an optional clause that does not affect the EXPLAIN output.
statement
is an SQL DML statement, by itself or enclosed in single or double quotation marks.
statement-name
is the name of a prepared SQL statement.
Considerations—EXPLAIN
•
Purpose of EXPLAIN reports
E[XIT] [ ; ]
EXPLAIN [ PLAN FOR ] { statement }
{ statement-name }