This structure is used to pass information from the Import API.
Table 4. Fields in the SQLUIMPT-OUT Structure
| Field Name | Data Type | Description |
|---|---|---|
| SIZEOFSTRUCT | INTEGER | Size of this structure in bytes. |
| ROWSREAD | INTEGER | Number of records read from the file during import. |
| ROWSSKIPPED | INTEGER | Number of records skipped before inserting or updating begins. |
| ROWSINSERTED | INTEGER | Number of rows inserted into the target table. |
| ROWSUPDATED | INTEGER | Number of rows in the target table updated with information from the imported records (records whose primary key value already exists in the table). |
| ROWSREJECTED | INTEGER | Number of records that could not be imported. |
| ROWSCOMMITTED | INTEGER | Number of records imported successfully and committed to the database. |
Language Syntax
C Structure
/* File: sqlutil.h */
/* Structure: SQLUIMPT-OUT */
/* ... */
SQL_STRUCTURE sqluimpt_out
{
sqluint32 sizeOfStruct;
sqluint32 rowsRead;
sqluint32 rowsSkipped;
sqluint32 rowsInserted;
sqluint32 rowsUpdated;
sqluint32 rowsRejected;
sqluint32 rowsCommitted;
};
/* ... */
|
COBOL Structure
* File: sqlutil.cbl
01 SQL-UIMPT-OUT.
05 SQL-SIZE-OF-UIMPT-OUT PIC 9(9) COMP-5 VALUE 28.
05 SQL-ROWSREAD PIC 9(9) COMP-5 VALUE 0.
05 SQL-ROWSSKIPPED PIC 9(9) COMP-5 VALUE 0.
05 SQL-ROWSINSERTED PIC 9(9) COMP-5 VALUE 0.
05 SQL-ROWSUPDATED PIC 9(9) COMP-5 VALUE 0.
05 SQL-ROWSREJECTED PIC 9(9) COMP-5 VALUE 0.
05 SQL-ROWSCOMMITTED PIC 9(9) COMP-5 VALUE 0.
*
|