SQL/MP Programming Manual for C

SQL/MP System Procedures

HP NonStop SQL/MP Programming Manual for C—429847-008

5-19

SQLGETOBJECTVERSION

The SQLGETOBJECTVERSION procedure returns the version of an SQL object.

SQLGETOBJECTVERSION returns zero after a successful operation or a nonzero

value to indicate an error or warning condition. For a description of SQL errors, see the

SQL/MP Messages Manual.

object_name

is the fully qualified file name of the SQL object for which you are requesting the

version. The name must be



Left justified and padded with spaces on the right



A maximum of 34 characters

sql_version

is the version of the SQL object. For information about versions of NonStop

SQL/MP, see the SQL/MP Version Management Guide.

SQLGETSYSTEMVERSION

The SQLGETSYSTEMVERSION procedure returns the version of SQL/MP file system

and disk process components running on a system. For a specific node, assume that

all SQL/MP components are of the same PVU.

SQLGETSYSTEMVERSION returns zero after a successful operation or a nonzero

value to indicate an error or warning condition. For a description of SQL errors, see the

SQL/MP Messages Manual.

If you request the version number for a remote node, SQLGETSYSTEMVERSION

returns information about the remote disk process. A successful call does not

guarantee that NonStop SQL/MP is installed on the remote node.

#include <cextdecs(SQLGETOBJECTVERSION)>

short SQLGETOBJECTVERSION (

char *object_name , /* i */

short *sql_version /* o */

);

Note. Although version 340 SQL/MP software supports the SQLGETOBJECTVERSION

procedure, HP might not support this procedure in a future RVU. If you are running version 300

(or later) SQL/MP software, use the GET VERSION statement to return the version of an SQL

object. For information about this statement, see the SQL/MP Reference Manual.