Dataloader/MP Reference Manual

Creating a Customized Version of DataLoader/MP
DataLoader/MP Reference Manual—424148-003
5-26
SQL Error Checking and Statistics Maintenance
operation was successful and, if so, how many rows were affected. This information is
used for the following:
•
To update DataLoader/MP’s internal statistics, which are printed out when
DataLoader/MP terminates
•
To determine the return value of the function, which will be positive if the operation
was successful and negative if the operation was unsuccessful
The three procedures are very similar; the differences between them involve what error
checks are made and what statistics are updated.
DTLDeletedResult
This procedure is designed to be called immediately after executing an embedded SQL
DELETE. It checks the outcome, updates DataLoader/MP’s internal statistics, and
returns a value of 1 if the delete was successful and a value of -1 otherwise.
The syntax for this procedure follows:
DTLInsertedResult
This procedure is designed to be called immediately after executing an embedded SQL
INSERT. It checks the outcome, updates DataLoader/MP’s internal statistics, and
returns a value of 1 if the insert was successful and a value of -1 otherwise.
The syntax for this procedure follows:
DTLUpdatedResult
This procedure is designed to be called immediately after executing an embedded SQL
UPDATE. It checks the outcome, updates DataLoader/MP’s internal statistics, and
returns a value of 1 if the update was successful and a value of -1 otherwise.
The syntax for this procedure follows:
short DTLDeletedResult( short* sqlcode, void* sqlca );
short DTLInsertedResult( short* sqlcode, void* sqlca );
short DTLUpdatedResult( short* sqlcode, void* sqlca );