NetBase SQL Shadowing Handbook

User Exits NetBase SQL
____________________________________________________________
3-12 QUEST Software, Inc. ver A0195
num_columns Number of columns in "data" buffer.
upd_columns Number of columns in "upd_data" buffer. This will be 0 unless
"record_type" is 26.
column_array Describes all columns in the "data" buffer. The first entry describes the
first column, the second describes column #2, etc.
column_type Defined as one of the following:
-1 Column contains a NULL value
0 Binary data
1 Character data
2 Integer data
3 Floating point data
4 Packed decimal data
6 NLS character data
column_length Length of the column in bytes.
update_array Description of the updated columns. Only the columns being updated
appear in this array, unlike the "column_array" which contains all
columns.
column_num Identifies the column number in the "upd_data" array.
Note: Currently, tables with up to 256 columns are supported.
data A buffer containing all columns of the record concatinated together.
The description of the columns is found in the "column_array". For
UPDATE records, the original data is stored here.
upd_data A buffer containing all updated columns. Unlike the "data" buffer, this
field contains only the updated columns. Note that if a column was not
updated, it will not appear in this buffer. This is why column number is
specified in the "update_array" field.
Note: Error values returned be the posting procedure for the "after" user exit are described in
the HP SQL manuals. Additional errors may be defined and will be added to this documentation.