SQL/MP Programming Manual for COBOL85

SQL/MP System Procedures
HP NonStop SQL/MP Programming Manual for COBOL85—429326-004
5-25
SQLGETOBJECTVERSION
sql-version output
PIC S9(4) COMP
is the version of the catalog. For information about versions of SQL/MP, see the
SQL/MP Version Management Guide.
error-info output
PIC S9(4) COMP
indicates the results of the SQLGETCATALOGVERSION call. If the call is
successful, error-info is 0. If an error occurs, error-info contains the
operating system or SQL error number. For a description of SQL errors, see the
SQL/MP Messages Manual.
SQLGETOBJECTVERSION
The SQLGETOBJECTVERSION procedure returns the version of an SQL object.
object-name required input
PIC X(length)
is the fully qualified file name of the SQL object for which you are requesting
information. The name must be
•
Left justified and padded with spaces on the right
•
A maximum of 34 characters
sql-version output
PIC S9(4) COMP
is the version of the SQL object. For information about versions of SQL/MP, see
the SQL/MP Version Management Guide.
Note. Although version 315 SQL/MP software supports the SQLGETCATALOGVERSION
procedure, HP might not support this procedure in a future PVU. If you are running version 300
(or later) SQL/MP software, use the GET VERSION OF CATALOG statement to return the
version of a catalog. For information about this statement, see the SQL/MP Reference Manual.
ENTER TAL "SQLGETOBJECTVERSION" USING
object-name,
sql-version
GIVING error-info.