SQL/MP Version Management Guide

Summary of Feature, Catalog, and Data Structure
Changes
Compaq NonStop™ SQL/MP Version Management Guide—429833-001
A-9
Changes to SQL Data Structures
Changes to SQL Data Structures
The structures of the SQLCA, SQLSA, and SQLDA data structures changed in the
following versions of SQL/MP:
For a detailed description of the changes to the SQL data structures, see the NonStop
SQL/MP Programming Manual for the language you are using.
Data Structure Changes in Version 2
The SQLDA data structure changed in version 2 of SQL. A new field was added, two
existing fields were given new meanings, and the eye-catcher literal value changed.
Table A-10. Table Changes in Version 350
Changes Column affected
Columns added to the FILES
table
PRIMARYEXT2, SECONDARYEXTENT2, EOF2,
FILEFORMAT
Columns in the FILES table
superseded by columnslisted
above
PRIMARYEXT, SECONDARYEXTENT, EOF
New value allowed in the
PARTIONARRAY column
A value of FORMAT2ENABLED refers to Format 2 enabled
tables or indexes.
Version 2 The structure of the SQLDA data structures changed, while the
structure of the SQLCA and SQLSA remained the same. Changes to
the SQLDA data structure are listed in Table A-11.
Version 300 The structure of the SQLDA and SQLSA data structures changed; the
changes to the SQL data structures in version 300 are listed in
Table A-12. The structure of the SQLCA remained the same. The
INCLUDE structure-name directives produce new literals.
Version 310 No new changes were made in the structure of the SQLSA, SQLDA,
and SQLCA data structures with the introduction of version 310.
Version 315 No new changes were made in the structure of the SQLSA, SQLDA,
and SQLCA data structures with the introduction of version 315.
Version 330 The structure of the SQLSA data structure changed; the changes to the
SQL data structures in version 330 are listed in Table A-13.