Home
SQL programmingYou can use the HCL OneDB™ implementation of the SQL language to develop applications for HCL OneDB™ database servers.
Guide to SQL: SyntaxThe HCL OneDB™ Guide to SQL: Syntax describes the syntax of the statements, data types, expressions, operators, and built-in functions of the HCL OneDB™ dialect of the SQL language.
SQL statementsThis chapter describes the syntax and semantics of SQL statements that are recognized by HCL OneDB™.
CREATE EXTERNAL TABLE StatementUse the CREATE EXTERNAL TABLE statement to define an external source that is not part of your database to load and unload data for your database.
External Table Examples The examples in this section illustrate different ways to load and unload data using external tables.
Unloading Data to External Tables from HCL OneDB™You unload data by creating an external table and inserting the data into it, or by selecting data from an internal table into an external file.
Unloading to HCL OneDB™ Data Files

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