SQL/MP Version Management Guide

Summary of Feature, Catalog, and Data Structure
Changes
Compaq NonStop™ SQL/MP Version Management Guide—429833-001
A-11
Data Structure Changes in Versions 310 and 315
Data Structure Changes in Versions 310 and 315
No new changes were made in the structure of the SQLSA, SQLDA and SQLCA data
structures with the introduction of version 310.
Data Structure Changes in Version 330
The SQLDA data structure changed in version 2 of SQL. A new section was added, two
existing fields were given new meanings, and the eye-catcher literal value changed.
Table A-13
lists the data structure changes made in version 330.
New SQLDA literals SQLDA_HEADER_LEN: Length of SQLDA header
fields
SQLDA_SQLVAR_LEN: Length of one SQLVAR entry
SQLDA_NAMESBUF_OVHD_LEN: Overhead length
added to the names buffer
SQLDA_COLLBUF_OVHD_LEN: Overhead length
added to collation buffer
New SQLDA declarations
allowed in the DATA_TYPE
field
_SQLDT_DOUBLE_F: Fixed-length double-byte
character
_SQLDT_DOUBLE_V: Variable length double-byte
character
New SQLDA character-set
declarations allowed in the
PRECISION field
_SQL_CHARSETID_UNKNOWN: 1-byte unknown
character set
_SQL_CHARSETID_KANJI: Japanese (same as Shift-
JIS)
_SQL_CHARSETID_KSC5601: Korean
_SQL_CHARSETID_88591: ISO 8859/1
_SQL_CHARSETID_88592: ISO 8859/2
_SQL_CHARSETID_88593: ISO 8859/3
_SQL_CHARSETID_88594: ISO 8859/4
_SQL_CHARSETID_88595: ISO 8859/5
_SQL_CHARSETID_88596: ISO 8859/6
_SQL_CHARSETID_88597: ISO 8859/7
_SQL_CHARSETID_88598: ISO 8859/8
_SQL_CHARSETID_88599: ISO 8859/9
Table A-13. Data Structure Changes in Version 330
Changes Elements Affected
New SQLSA fields MASTER^EXECUTOR^CPU^TIME: CPU time, in
microseconds, of the master executor
TOTAL^ESP^CPU^TIME: Total CPU time, in
microseconds, used by all ESPs
TOLTAL^SORTPROG^CPU^TIME: Total CPU time, in
microseconds, used by all SORTPROGs
Table A-12. Data Structure Changes in Version 300 (page 2 of 2)
Changes Elements Affected