SQL Programming Manual for Pascal

NonStop SQL System Procedures
HP NonStop SQL Programming Manual for Pascal—528614-001
4-20
SQLGETOBJECTVERSION
objectname input
EXTADDR
specifies the fully qualified file name of the SQL object for which you are
requesting information. The name must be:
•
Left justified and padded with blanks
•
No longer than 34 characters
sqlversion output
INT16
is the version of the SQL object. The value returned is:
1 Version 1 object; fully compatible with NonStop SQL C10
2 Version 2 object; fully compatible with NonStop SQL C30
SQLGETOBJECTVERSION returns 0 if the operation is successful. Otherwise,
SQLGETOBJECTVERSION returns the NonStop Kernel operating system, file system,
or SQL error number.
Guidelines
If the object uses any Version 2 features listed in Tabl e 4-4 on page 4-20,
SQLGETOBJECTVERSION returns a value representing a Version 2 object.
Otherwise, SQLGETOBJECTVERSION returns a value representing a Version 1
object.
The following attributes are Version 2 features that do not cause
SQLGETOBJECTVERSION to return the value 2. To determine whether these
attributes are present, a program must query the catalog tables containing the
description of the table or view.
Table 4-4. Version 2 (NonStop SQL C30) Features
Category Features
Data types FLOAT (includes REAL and DOUBLE PRECISION)
DATETIME (includes DATE, TIME, and TIMESTAMP)
INTERVAL
UPSHIFT CHARACTER or VARCHAR
Functions Exponentiation
Date-time functions
UPSHIFT function
Features Columns that can contain null values
Clustering key
Constraints using Version 2 data types or functions