SQL Programming Manual for Pascal

NonStop SQL System Procedures

HP NonStop SQL Programming Manual for Pascal—528614-001

4-19

SQLGETCATALOGVERSION

The SQLGETCATALOGVERSION procedure returns a value that indicates the version

of an SQL catalog.

catalogname input

EXTADDR

specifies the fully qualified file name of the catalog for which you are

requesting information. The name must be:

•

Left justified and padded with blanks

•

No longer than 26 characters

If you omit catalogname, SQLGETCATALOGVERSION uses the default catalog.

sqlversion output

INT16

is the version of the catalog. The value returned is:

1 Version 1 catalog; created by NonStop SQL C10 software

2 Version 2 catalog; created by NonStop SQL C30 software

For more information on catalog versions, see Appendix D.

SQLGETCATALOGVERSION returns 0 if the operation is successful; otherwise,

SQLGETCATALOGVERSION returns the NonStop Kernel operating system, file

system, or SQL error number.

SQLGETOBJECTVERSION

The SQLGETOBJECTVERSION procedure returns a value that indicates the NonStop

SQL object version. This value represents the earliest NonStop SQL release that can

perform all DML and most DDL operations defined for a given table, view, or index.

FUNCTION SQLGETCATALOGVERSION TAL EXTENSIBLE

(OPTIONAL catalogname : EXTADDR;

EXTREF VAR sqlversion : INT16)

: INT16;

FUNCTION SQLGETOBJECTVERSION TAL EXTENSIBLE

(OPTIONAL objectname : EXTADDR;

EXTREF VAR sqlversion : INT16)

: INT16;