SQL/MP Version Management Guide

Summary of Feature, Catalog, and Data Structure
Changes
Compaq NonStop™ SQL/MP Version Management Guide—429833-001
A-10
Data Structure Changes in Version 300
Table A-11 lists the data structure changes made in version 2.
Data Structure Changes in Version 300
Table A-12 lists the SQLSA and SQLDA data structures changes made in version 300.
Table A-11. Data Structure Changes in Version 2
Changes Elements Affected
New SQLDA field PRECISION: Precision information for columns whose
data type is one of the following: FLOAT, REAL,
DOUBLE PRECISION, DATETIME, DATE, TIME,
TIMESTAMP, or INTERVAL
Changed SQLDA fields NULL_INFO: Set to -1 if a null value is allowed in the
corresponding SELECT column
IND_PTR: Used for the extended address of a null
indicator variable (this field was a RESERVED field);
user program must initialize IND_PTR to point to input
and output indicator variables
New eye-catcher value in the
SQLDA structure
D1: Value returned by INCLUDE SQLDA (the eye
catcher was DA in version 1)
Table A-12. Data Structure Changes in Version 300 (page 1 of 2)
Changes Elements Affected
New SQLSA field OUTPUT_COLLATION_LEN: Length of the output
buffer that holds collations
New SQLSA statement type SQL_STATEMENT_GET: GET VERSION statement
type
New SQLDA field CPRL_PTR: Address of the collation buffer
New SQLDA buffer Collation buffer: Contains collations