SQL/MX 3.x Reference Manual (H06.22+, J06.11+)

MXCI Commands

HP NonStop SQL/MX Reference Manual—640322-001

4-43

GET VERSION OF STATEMENT Command

The GET VERSION OF STATEMENT command displays the plan version of the

specified prepared statement.

statement-name

is the name of a prepared statement for which plan version information is

requested. There is no default for statement-name. The statement must have

been previously prepared in the same MXCI session as the one where the GET

VERSION command is issued.

Error Conditions for GET VERSION OF STATEMENT

An error for the GET VERSION OF STATEMENT command occurs when:

•

The specified statement does not exist.

•

An invalid statement name is specified.

Example of GET VERSION OF STATEMENT

>> prepare myquery from select * from cat.sch.t22;

>> GET VERSION OF STATEMENT myquery;

VERSION: 1200

GET VERSION OF STATEMENT statement-name;