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:
  • Start of changeSpecify the length of VARCHAR, BLOB, CLOB, DBCLOB, ROWID, VARBINARY, TIMESTAMP, and TIMESTAMP WITH TIME ZONE data in the input file.End of change
  • Explicitly define all input field specifications.
  • Use DECIMAL EXTERNAL(length,scale) in full.
  • Specify decimal points explicitly in the input file.