SQL Programming Manual for TAL

System Procedures
HP NonStop SQL Programming Manual for TAL—527887-001
4-20
SQLGETOBJECTVERSION
objectname input
STRING .EXT
specifies the fully qualified file name of the NonStop SQL object for which you are
requesting information. The name must be:
•
Left justified and padded with blanks
•
A maximum of 34 characters
sqlversion output
INT .EXT
is the version of the object. The value returned is:
1. Version 1 object that is compatible with NonStop SQL C10
2. Version 2 object that is compatible with NonStop SQL C30
Guidelines
If the object uses any of the Version 2 features shown in this table,
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 in sqlversion. To determine if these
attributes are present, a program must query the catalog tables containing the
description of the table or view.
•
NO AUDITCOMPRESS attribute
•
HEADING attribute
•
HELP TEXT attribute
Table 4-4. NonStop SQL Release C30 (Version 2) 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