Specifying input fields
You can specify input fields in the LOAD utility control statement.
Procedure
To specify input fields in a LOAD utility control statement:
Take one of the following actions:
- Specify the length of VARCHAR, BLOB, CLOB, DBCLOB, ROWID, VARBINARY, TIMESTAMP, and TIMESTAMP WITH TIME ZONE data in the input file.
- Explicitly define all input field specifications.
- Use DECIMAL EXTERNAL(length,scale) in full.
- Specify decimal points explicitly in the input file.