Unloading to a Delimited File

You can unload data to a delimited-ASCII text file from a table, as the following example shows:

SELECT * FROM employee 
WHERE hiredate > "1/1/1996"
INTO EXTERNAL emp_ext
USING (
    DATAFILES ("DISK:1:/work2/mydir/emp.unl") 
    );

Another SQL statement sequence to unload from this table is as follows:

CREATE EXTERNAL TABLE emp_ext 
SAMEAS employee
USING (
    DATAFILES ("DISK:1:/work2/mydir/emp.dat") 
    );
INSERT INTO emp_ext SELECT * FROM employee;

Delimited files are ASCII by default. For EBCDIC files, specify CODESET EBCDIC in the USING clause.