DataLoader/MX Reference Manual (G06.24+)

Creating a Customized Version of DataLoader/MX
DataLoader/MX Reference Manual—525872-002
5-26
SQL Error Checking and Statistics Maintenance
•
Determine the return value of the function, which is positive if the operation is
successful and negative if the operation is unsuccessful
The three procedures are very similar. They differ only in the error checks they make
and thw statistics they update.
DTLDeletedResult
This procedure is designed to be called immediately after you execute an embedded
SQL DELETE. It checks the outcome, updates DataLoader/MX internal statistics, and
returns a value of 1 if the delete was successful and a value of -1, otherwise.
The syntax is:
If a customized DataLoader/MX build is done with the MP option, the syntax is:
DTLInsertedResult
This procedure is designed to be called immediately after you execute an embedded
SQL INSERT. It checks the outcome, updates DataLoader/MX internal statistics, and
returns a value of 1 if the insert was successful and a value of -1, otherwise.
The syntax is:
If a customized DataLoader/MX build is done with the MP option, the syntax is:
DTLUpdatedResult
This procedure is designed to be called immediately after you execute an embedded
SQL UPDATE. It checks the outcome, updates DataLoader/MX internal statistics, and
returns a value of 1 if the update was successful and a value of -1, otherwise.
The syntax is:
If a customized DataLoader/MX build is done with the MP option, the syntax is:
short DTLDeletedResult( char *sqlstate );
short DTLDeletedResult( short *sqlcode, void *sqlca );
short DTLInsertedResult( char *sqlstate );
short DTLInsertedResult( short *sqlcode, void *sqlca );
short DTLUpdatedResult( char *sqlstate );
short DTLUpdatedResult( short *sqlcode, void *sqlca );