This structure is used to pass information to sqluimpr - Import.
Table 66. Fields in the SQLUIMPT-IN Structure
| Field Name | Data Type | Description |
|---|---|---|
| SIZEOFSTRUCT | INTEGER | Size of this structure in bytes. |
| COMMITCNT | INTEGER | The number of records to import before committing them to the database. A COMMIT is performed whenever commitcnt records are imported. |
| RESTARTCNT | INTEGER | The number of records to skip before starting to insert/update records. This parameter should be used if a previous attempt to import records fails after some records have been committed to the database. The parameter's value represents a starting point for the next import. |
Language Syntax
C Structure
/* File: sqlutil.h */
/* Structure: SQLUIMPT-IN */
/* ... */
SQL_STRUCTURE sqluimpt_in
{
unsigned long sizeOfStruct;
unsigned long commitcnt;
unsigned long restartcnt;
};
/* ... */
|
COBOL Structure
* File: sqlutil.cbl
01 SQL-UIMPT-IN.
05 SQL-SIZE-OF-UIMPT-IN PIC 9(9) COMP-5 VALUE 12.
05 SQL-COMMITCNT PIC 9(9) COMP-5 VALUE 0.
05 SQL-RESTARTCNT PIC 9(9) COMP-5 VALUE 0.
*
|