This structure is used to output information after a call to sqluload - Load.
Table 78. Fields in the SQLULOAD-OUT Structure
| Field Name | Data Type | Description |
|---|---|---|
| SIZEOFSTRUCT | sqluint32 | Size of this structure in bytes. |
| ROWSREAD | sqluint32 | Number of records read during the load operation. |
| ROWSSKIPPED | sqluint32 | Number of records skipped before the load operation begins. |
| ROWSLOADED | sqluint32 | Number of rows loaded into the target table. |
| ROWSREJECTED | sqluint32 | Number of records that could not be loaded. |
| ROWSDELETED | sqluint32 | Number of duplicate rows deleted. |
| ROWSCOMMITTED | sqluint32 | 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
{
sqluint32 sizeOfStruct;
sqluint32 rowsRead;
sqluint32 rowsSkipped;
sqluint32 rowsLoaded;
sqluint32 rowsRejected;
sqluint32 rowsDeleted;
sqluint32 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.
*
|