SQL Programming Manual for TAL

System Procedures
HP NonStop SQL Programming Manual for TAL—527887-001
4-21
SQLGETSYSTEMVERSION
These attributes, however, are considered Version 2 features by the catalog manager
process, which handles DDL statements. Tables and views that use these features
must be handled by DDL statements executed on a NonStop SQL C30 system.
SQLGETSYSTEMVERSION
The SQLGETSYSTEMVERSION procedure returns the version of NonStop SQL file
system and disk process components that are running on a system.
error returned value
INT
returns the outcome of the operation. Zero (0) indicates a successful operation. For
more information on the description of SQL errors, see the SQL/MP Messages
Manual.
nodenumber input
INT
specifies the node number of the system for which you are requesting information.
The default is the local system.
sqlversion output
INT .EXT
is the NonStop SQL software release version for the system. The values for
sqlversion are:
1. NonStop SQL C10 (release 1)
2. NonStop SQL C30 (release 2)
Guidelines
Follow these guidelines when you call the SQLGETSYSTEMVERSION procedure:
•
For a specific system, you can assume that all NonStop SQL components are the
same release level.
•
When you request the version number for a remote system,
SQLGETSYSTEMVERSION returns the version information for the remote disk
process. A successful call does not guarantee that NonStop SQL is installed on the
remote system.
•
If you try to return the version of a remote system that has NonStop SQL release
C10 installed, SQLGETSYSTEMVERSION returns an error.
error := SQLGETSYSTEMVERSION ( [ nodenumber ] ! i
, sqlversion ) ; ! o