SQL Programming Manual for Pascal

NonStop SQL System Procedures
HP NonStop SQL Programming Manual for Pascal—528614-001
4-21
SQLGETSYSTEMVERSION
•
NO AUDITCOMPRESS attribute
•
HEADING attribute
•
HELP TEXT attribute
These three attributes, however, are considered Version 2 features by the catalog
manager process, which handles DDL statements. The tables and views that use
these features must be handled by DDL statements executed on a NonStop SQL C30
system.
SQLGETSYSTEMVERSION
The SQLGETSYSTEMVERSION procedure obtains the version of the NonStop SQL
file system and disk process components that are running on a system.
nodenumber input
INT16
specifies the node number of the system for which you are requesting
information. If this parameter is omitted, the local system is assumed.
sqlversion output
INT16
is the SQL software release version for the system. The value returned is:
1 NonStop SQL Release 1 (C10)
2 NonStop SQL Release 2 (C30)
Guidelines
•
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.
•
You cannot request the version of a remote system with Release 1 (NonStop SQL
C10) installed. If you request the version of a remote system that uses Release 1,
the SQLGETSYSTEMVERSION returns an error.
FUNCTION SQLGETSYSTEMVERSION TAL EXTENSIBLE
(OPTIONAL nodenumber : INT16;
EXTREF VAR sqlversion : INT16)
: INT16;