Loading Complex Data Types

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)|