DataLoader/MX Reference Manual (H06.03+, J06.03+)

Creating a Customized Version of DataLoader/MX
DataLoader/MX Reference Manual—543544-001
5-27
Generating Test Data
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:
Generating Test Data
You can use DataLoader/MX, not only to load data from an existing system, but also to
create test data. DataLoader/MX has several utility procedures that help create test
data with these requirements:
•
You must be able to generate data in quantities equal to the quantity of real data.
•
You must be able to control the distribution of data so that it is representative of
real data, or at least what you believe real data will look like.
•
The data values themselves must have some resemblance to real data. For
example, a name field containing the following test data might provide the bulk and
maybe even the distribution needed, but does not resemble actual data:
AAAAAAAAAAAAAAAAAAAAAAAAA
AAAAAAAAAAAAAAAAAAAAAAAAB
AAAAAAAAAAAAAAAAAAAAAAAAC
...
ZZZZZZZZZZZZZZZZZZZZZZZZZ
short DTLInsertedResult( char *sqlstate );
short DTLInsertedResult( short *sqlcode, void *sqlca );
short DTLUpdatedResult( char *sqlstate );
short DTLUpdatedResult( short *sqlcode, void *sqlca );