SQL/MP Reference Manual

HP NonStop SQL/MP Reference Manual—523352-013
E-13
EXIT Command
EXIT Command
EXIT is an SQLCI command that ends an SQLCI session. Pressing Ctrl-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.
Example—EXIT
In this 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 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

You can use the information in an EXPLAIN report to tune queries and to help
determine whether to add or drop indexes for a database. For listings of sample
E[XIT] [ ; ]
EXPLAIN [ PLAN FOR ] { statement }
{ statement-name }