NetBase SQL Shadowing Handbook

User Exits NetBase SQL
____________________________________________________________
3-4 QUEST Software, Inc. ver A0195
Notes on User Exit Structure
All of the user exits (both export user exits and post user exits) have the same set of parameters.
The sqlca parameter is the same as the sqlca as defined in the SQL manual for the language of
your choice.
The comarea parameter has flags that are returned by the user exit. These flags control the
processing of that record. The action field of the comarea should always be set by the user exit,
since it is not initialized by the calling program. The comarea contains a large area (512 bytes)
set aside for the user exit which is not in any way affected by the program calling it.
The header record contains all of the information about the record, the name of the DBE, the
name of the Table (for UPDATE, INSERT, and DELETE records), the name of the user, and the
time the record was originally committed. The header record also has pointers into the data
records.
The data parameter has the record that was UDPATED, INSERTED, or DELETED.
The upd_data is used only for UPDATE records, and it contains the data which was updated.
A transaction consists of a BEGIN record, one or more INSERT, UPDATE, or DELETE records,
and a COMMIT record. The user exit is called for each of these records. One of the options of
the user exit is to delete the current record. It is not valid to delete a BEGIN or a COMMIT
record.