NetBase SQL Shadowing Handbook

NetBase SQL User Exits
____________________________________________________________
ver A0195 QUEST Software, Inc. 3-7
The individual fields within header are defined as follows:
DBEname Name of the DBE (fully-qualified).
owner_name Owner of the table.
table_name Name of the table.
user_name User name of the entity that committed the transaction. Only
valid if record_type = 1.
commit_time Time the record was committed. Only valid if record_type = 1.
This field is in the same format as the SQL DATETIME data
type.
record_type Type of record. Defined as:
1 COMMIT TRANSACTION record
15 BEGIN TRANSACTION record
24 INSERT tuple
25 DELETE tuple
26 UPDATE tuple
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.