Command file to load complex data types

You can create dbload command files that load columns containing complex data types into tables.

You can use dbload with the following data types:
  • A BLOB or CLOB
  • A SET inside a ROW type
The dbload utility does not work with the following data types:
  • A CLOB or BLOB inside a ROW type
  • A ROW type inside a SET
Important: All the load utilities (dbexport, dbimport, dbload, onload, onunload, and onxfer) rely on an export and import function. If you do not define this function when you write a user-defined data type, you cannot use these utilities.

Loading a new data type inside another data type can cause problems if the representation of the data contains handles. If a string represents the data, you must be able to load it.

You can use dbload with named row types, unnamed row types, sets, and lists.