Loading Complex Data Types (IDS)

In a LOAD FROM file, complex data types appear as follows:

• Collections are introduced with the appropriate constructor (SET, MULTISET, or LIST), and their elements are enclosed in braces ({ }) and separated with a comma, as follows:

  constructor{val1 , val2 , ... }

  For example, to load the SET values {1, 3, 4} into a column whose data type is SET(INTEGER NOT NULL), the corresponding field of the LOAD FROM file appears as:

  |SET{1 , 3 , 4}|

• Row types (named and unnamed) are introduced with the ROW constructor and their fields are enclosed with parentheses and separated with a comma, as follows:

  ROW(val1 , val2 , ... )

  For example, to load the ROW values (1, 'abc'), the corresponding field of the LOAD FROM file appears as:

  |ROW(1 , abc)|