SQL/MX 3.1 Reference Manual (H06.23+, J06.12+)

SQL/MX Functions and Expressions
HP NonStop SQL/MX Release 3.1 Reference Manual—663850-001
9-201
Example of VERSION_INFO
ANSI names in the input value parameter must be fully qualified, in external format.
Expand node names are case-insensitive. Both input parameters must be
character-valued expressions.
Example of VERSION_INFO
select * from table (version_info ('SCHEMA', 'CAT.SCH'));
E_TYPE E_VALUE VERSION NODE_NAME MXV___
------- -------- ------- --------- ----
SCHEMA CAT.SCH 1200 \REMOTE 1200
SCHEMA CAT.SCH 1200 \XYZZY 1400
...
CONSTRAINT ANSI name of constraint OFV of constraint
TRIGGER ANSI name of trigger OFV of trigger
PROCEDURE ANSI name of procedure OFV of procedure
MPALIAS ANSI name of mpalias OFV of mpalias
MODULE ANSI name of module Module version
Table 9-9. VERSION Output Column Values E_TYPE and E_VALUE
Parameters (page 2 of 2)
E_TYPE E_VALUE VERSION