LIST data type example

The following statement creates a table in which the month_sales column is defined as a LIST:

CREATE TABLE sales_person  
   (
      name CHAR(30),  
      month_sales LIST(MONEY NOT NULL)  
   );

The data from the sales_person table is unloaded into the sales.unl file. Each data row contains two delimited fields, as follows:

Jane Doe|LIST{'4.00','20.45','000.99'}|
Big Earner|LIST{'0000.00','00000.00','999.99'}|

This dbload example shows how to insert data that contains LIST data types into the sales_person table in the new database. Put double quotes around each LIST data type or the insert does not work.

FILE sales_person.unl DELIMITER '|' 2;
INSERT INTO sales_person 
VALUES ('Jenny Chow', "{587900, 600000}");