SQL/MP Programming Manual for C

Converting C Programs
HP NonStop SQL/MP Programming Manual for C—429847-008
D-2
Generating SQLDA Structures
Table D-1 lists the changes to the SQL data structures and the changes that occurred
with each version of NonStop SQL/MP.
Generating SQLDA Structures
If an existing C program generates SQLDA structures and you are converting the
program to run on version 300 (or later) SQL/MP software, you might need one or
more of these combinations of SQLDA structures:

A version 300 (or later) SQLDA structure

A version 1 or 2 SQLDA structure

A version 300 (or later) SQLDA structure and a version 1 or 2 SQLDA structure
Table D-1. Changes to SQL Data Structures
Version
Size,
Bytes
Eye-Catcher
Value New Fields
SQLCA Structure
1, 2, Š 300 430 CA None
SQLSA Structure
1838SA–
2 838 SA None
300 - 325 838 SA output_collations_len
Š 330 1790 SA master_executor_elapsed_time
total_esp_cpu_time
total_sortprog_cpu_time
vsbb_write
vsbb_flushed
SQLDA Structure
1 Variabl
e
DA –
2 Variabl
e
D1 precision, null_info, ind_ptr
Š 300 Variabl
e
D1 cprl_ptr, user-defined collation buffer