Delimiter form of the FILE and INSERT statements

The FILE and INSERT statements that define information for the dbload utility can appear in a delimiter form.

The following example of a dbload command file illustrates a simple delimiter form of the FILE and INSERT statements. The example is based on the stores_demo database. An UNLOAD statement created the three input data files, stock.unl, customer.unl, and manufact.unl. 
FILE stock.unl DELIMITER '|' 6;
INSERT INTO stock;
FILE customer.unl DELIMITER '|' 10;
INSERT INTO customer;
FILE manufact.unl DELIMITER '|' 3;
INSERT INTO manufact;

To see the .unl input data files, refer to the directory $ONEDB_HOME/demo/prod_name (UNIX™ or Linux™) or %ONEDB_HOME%\demo\prod_name (Windows™).