SQL/MP Installation and Management Guide

Querying SQL/MP Catalogs
HP NonStop SQL/MP Installation and Management Guide—523353-004
6-16
Displaying Catalog, Object, and Program Versions
In the information returned from either the VERSIONS or the CATALOGS table, the
code A010 indicates a version 1 catalog, A011 indicates a version 2 catalog, A300
indicates a version 300 catalog, A310 indicates a version 310 catalog, A315 indicates
a version 315 catalog, and so on.
You can also determine the version of SQL/MP tables, views, indexes, and collations
by using the FILEINFO command with the DETAIL option. (You cannot use the
FILEINFO command to obtain catalog versions.)
You can also obtain version information programmatically by issuing procedure calls.
For more information about this method, see the SQL/MP Version Management Guide.