Unloading to HCL OneDB Data Files

About this task

To unload from the employee table to a table in HCL OneDB™ internal format, use statements similar to the following ones: 
SELECT * FROM employee 
WHERE hiredate > "1/1/1996" 
INTO EXTERNAL emp_ext
USING (
   FORMAT 'INFORMIX', 
    DATAFILES ("DISK:/work2/mydir/emp.dat")
    );

Because the output files use HCL OneDB internal representation, you need to specify the FORMAT 'INFORMIX' option in the USING clause. (The default is delimited-ASCII format.)