SQL Programming Manual for TAL

System Procedures

HP NonStop SQL Programming Manual for TAL—527887-001

4-19

SQLGETCATALOGVERSION

The SQLGETCATALOGVERSION procedure returns the version of an SQL catalog.

error returned value

INT

returns the outcome of the operation. Zero (0) indicates a successful operation. For

a description of SQL errors, see the SQL/MP Messages Manual.

catalogname input

STRING .EXT

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

information. The name must be:

•

Left justified and padded with blanks

•

A maximum of 26 characters

If you omit catalogname, SQLGETCATALOGVERSION uses the default catalog.

sqlversion output

INT .EXT

is the version of the catalog. The procedure returns one of these values:

1. Version 1 catalog (created by NonStop SQL C10)

2. Version 2 catalog (created by NonStop SQL C30)

SQLGETOBJECTVERSION

The SQLGETOBJECTVERSION procedure returns a value that indicates the SQL

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

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

error returned value

INT

returns the outcome of the operation. Zero (0) indicates a successful operation. For

a description of SQL errors, see the SQL/MP Messages Manual.

error := SQLGETCATALOGVERSION ( [ catalogname ] ! i

, sqlversion ) ; ! o

error := SQLGETOBJECTVERSION ( objectname, ! i

sqlversion ) ; ! o