Large Object Data Loads

Load LONG BINARY and LONG VARCHAR data using the extended syntax of the LOAD TABLE statement.

You can load large object data of unlimited size, unless restricted by the operating system, from a primary file in ASCII or BCP format. The maximum length of fixed-width data loaded from a primary file into large object columns is 32K - 1.

You can also specify a secondary load file in the primary load file. Each individual secondary data file contains exactly one LONG BINARY or LONG VARCHAR cell value.

• Extended LOAD TABLE Syntax
  LOAD TABLE has extended syntax for loading large object data.
• Large Object Data Load Example
  Create and load a table with LONG BINARY data.
• Control of Load Errors
  The database option SECONDARY_FILE_ERROR allows you to specify the action of the load if an error occurs while opening or reading from a secondary BINARY FILE or ASCII FILE.
• Load of Large Object Data with Trailing Blanks
  The LOAD TABLE...STRIP option has no effect on LONG VARCHAR data.
• Load of Large Object Data with Quotes
  The LOAD TABLE...QUOTES option does not apply to loading LONG BINARY (BLOB) or LONG VARCHAR (CLOB) data from the secondary file, regardless of its setting,
• Truncation of Partial Multibyte Character Data
  Partial multibyte LONG VARCHAR data is truncated during the load according to the value of the TRIM_PARTIAL_MBC database option.
• Load Support of Large Object Variables
  Large object variables are supported by the LOAD TABLE, INSERT…VALUES, INSERT…SELECT, INSERT…LOCATION, SELECT…INTO, and UPDATE SQL statements.