NetBase SQL Shadowing Handbook

User Exits NetBase SQL
____________________________________________________________
3-10 QUEST Software, Inc. ver A0195
The individual fields are defined as follows:
action Set by user exit procedure to cause various actions by the exporting
process. The valid values are:
0 Process record normally. Post the record as normal (before
only) or continue with next record (after).
1 Ignore record completely. The record will be thrown away.
This can easily cause synchronization errors. Used by "before"
only.
2 Disable all subsequent calls to the user exit facility.
3 Roll back transaction. Ignore all subsequent updates in this
transaction.
4 Do not post for this table. This is used if a table goes out of
sync, but would allow posting of other tables.
5 Retry this transaction, setting UNIQUE CONSTRAINTS to
"DEFERRED." ("after" only.)
6 Retry this transaction, setting REFERENCIAL CONSTRAINTS
to "DEFERRED." ("after" only.)
7 Tells the import process to rollback and reapply. Used when
the apply log fails because the pre-image could not be found
and the post_sql_exit_after userexit fixes up the data in the
buffer so that it will succeed. ("after" only.)
Note: The import process cannot perform this function if the
BEGIN record for the transaction is not in its internal buffers.
In this case it will call the userexit again with the
header.record_type set to 10000.
-1 Stop posting. This should normally be done only on a BEGIN
or COMMIT transaction to prevent rollbacks.
-2 Do not post for this table. This is used if a table goes out of
sync, but would allow posting of other tables. Sets the SYNC
flag for the table.
status Set by user exit procedure to send a message to the console. If a
positive value is set, this message in the catalog file NBEXPSQL.CAT,
set 5, will be sent to the console.
error1 / error2 Set by user exit procedure. If status is non-zero, these values will be
inserted in the message sent to the console.
export_node Set by calling procedure to indicate the node number that transactions
are being exported from. This is the remote node.
import_node Set by calling procedure to indicate the node number that transactions
are being applied to. This is the local node.