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

MXCI Commands
HP NonStop SQL/MX Reference Manual—640322-001
4-42
GET VERSION OF PROCEDURE Command
GET VERSION OF PROCEDURE Command
The GET VERSION OF PROCEDURE command displays the plan version of the
specified procedure in the specified module.
module-name
is the name of the module for which version information is desired. There is no
default for module-name and MXCI default catalog and schema do not apply. If a
module exists in metadata and a module with the same name also exists in the
USERMODULES OSS directory, the module in metadata is reported. If the module
exists in an OSS directory other than USERMODULES, the full OSS path must be
specified as module name.
procedure-name
is the name of the specific procedure in the module for which plan version
information is requested.
Error Conditions for GET VERSION OF PROCEDURE
An error for the GET VERSION OF PROCEDURE occurs when:
•
The specified module does not exist.
•
The specified procedure name does not exist in the specified module.
•
The specified procedure name is invalid.
•
The specified module cannot be accessed.
•
An invalid module name is specified.
Example of GET VERSION OF PROCEDURE
>> GET VERSION OF PROCEDURE ('/usr/sqlmods/CAT.SCH.MOD',
'PROC47');
VERSION: 1200
GET VERSION OF PROCEDURE ('module-name','procedure-name');
Note. The module name must be specified in single quotes.