Moving Data Across the DB2 Family

Chapter 6. Load with DB2 Distributed 109

int rc = 0;

rc = db2Load(db2Version810, pLoadStruct, pSqlca);

printf("rc from load : %d\n", rc);

printf("Sqlcode from load : %d\n", pSqlca->sqlcode);

if (pSqlca->sqlcode == 0)

{

db2LoadOut *pLoadOut = pLoadStruct->poLoadInfoOut;

int iRowsRead = 0;

int iRowsSkipped = 0;

int iRowsLoaded = 0;

int iRowsRejected = 0;

int iRowsDeleted = 0;

int iRowsCommitted = 0;

printf("\n");

iRowsRead = pLoadOut->oRowsRead;

printf("Number of rows read : %d\n", iRowsRead);

iRowsSkipped = pLoadOut->oRowsSkipped;

printf("Number of rows skipped : %d\n", iRowsSkipped);

iRowsLoaded = pLoadOut->oRowsLoaded;

printf("Number of rows loaded : %d\n", iRowsLoaded);

iRowsRejected = pLoadOut->oRowsRejected;

printf("Number of rows