This structure is used to output information after a call to Load API.
Table 7. Fields in the SQLULOAD-OUT Structure
| Field Name | Data Type | Description |
|---|---|---|
| SIZEOFSTRUCT | UNSIGNED LONG | Size of this structure in bytes. |
| ROWSREAD | UNSIGNED LONG | Number of records read during the load operation. |
| ROWSSKIPPED | UNSIGNED LONG | Number of records skipped before the load operation begins. |
| ROWSLOADED | UNSIGNED LONG | Number of rows loaded into the target table. |
| ROWSREJECTED | UNSIGNED LONG | Number of records that could not be loaded. |
| ROWSDELETED | UNSIGNED LONG | Number of duplicate rows deleted. |
| ROWSCOMMITTED | UNSIGNED LONG | The total number of processed records: the number of records loaded successfully and committed to the database, plus the number of skipped and rejected records. |
Language Syntax
C Structure
/* File: sqlutil.h */
/* Structure: SQLULOAD-OUT */
/* ... */
SQL_STRUCTURE sqluload_out
{
unsigned long sizeOfStruct;
unsigned long rowsRead;
unsigned long rowsSkipped;
unsigned long rowsLoaded;
unsigned long rowsRejected;
unsigned long rowsDeleted;
unsigned long rowsCommitted;
};
/* ... */
|
COBOL Structure
* File: sqlutil.cbl
01 SQLULOAD-OUT.
05 SQL-SIZE-OF-STRUCT PIC 9(9) COMP-5 VALUE 28.
05 SQL-ROWS-READ PIC 9(9) COMP-5.
05 SQL-ROWS-SKIPPED PIC 9(9) COMP-5.
05 SQL-ROWS-LOADED PIC 9(9) COMP-5.
05 SQL-ROWS-REJECTED PIC 9(9) COMP-5.
05 SQL-ROWS-DELETED PIC 9(9) COMP-5.
05 SQL-ROWS-COMMITTED PIC 9(9) COMP-5.
*
|