DataLoader/MX Reference Manual (G06.24+)

DataLoader/MX Reference Manual—525872-002
C-1
C C-Only Error Functions
This appendix describes C-only SQL error-checking functions. These functions work
for C programs, but do not work for COBOL programs.
Functions are retained for compatibility with earlier versions of DataLoader, but you
should not use them for new customizations. Instead, use their replacements
(DTLDeletedResult, DTLInsertedResult, and DTLUpdatedResult). (See SQL Error
Checking and Statistics Maintenance on page 5-25 for descriptions of replacement
functions.)
DTLWasDeleted
This procedure is designed to be called immediately after executing an embedded SQL
DELETE. It checks the outcome, updates DataLoader internal statistics, and returns a
value of 1 if the DELETE was successful and a value of -1 otherwise. This procedure
has been replaced by DTLDeletedResult.
The syntax is:
DTLWasInserted
This procedure is designed to be called immediately after executing an embedded SQL
INSERT. It checks the outcome, updates DataLoader internal statistics, and returns a
value of 1 if the INSERT was successful and a value of -1 otherwise. This procedure
has been replaced by DTLInsertedResult.
The syntax is:
DTLWasUpdated
This procedure is designed to be called immediately after executing an embedded SQL
UPDATE. It checks the outcome, updates DataLoader’s internal statistics, and returns
a value of 1 if the UPDATE was successful and a value of -1 otherwise. This procedure
has been replaced by DTLUpdatedResult.
The syntax is:
short DTLWasDeleted( void );
short DTLWasInserted( void );
short DTLWasUpdated( void );