The CREATE EXTERNAL TABLE Statement

Home | Previous Page | Next Page Other Data Restore Utilities > Restoring Table-level Data > The archecker Schema Reference >

The CREATE EXTERNAL TABLE Statement

The CREATE EXTERNAL TABLE statement describes the schema of an external target table.

Syntax

The syntax of the CREATE EXTERNAL TABLE statement for the archecker schema file is not identical to the SQL CREATE EXTERNAL TABLE statement.

                                   .-,-----------------.
                                   V                   |
>>-CREATE EXTERNAL TABLE--name--(----column--data_type-+--)----->
 
>--USING--(--"filename"--+------------------+--)--;------------><
                         '-,--+-DELIMITED-+-'
                              '-INFORMIX--'

Element	Description
column	The name of the column. Must conform to SQL identifier syntax rules. For more information, see the IBM Informix: Guide to SQL Syntax.
data_type	The built-in data type of the column. For more information about data types, see the IBM Informix: Guide to SQL Reference.
filename	Either the name of the file in which to place the data or a pipe device. The pipe device must exist prior to starting the archecker utility.
name	The name of the table to store the external data. Must be unique among names of tables, views, and synonyms in the current database. Must conform to SQL database object name rules. For more information, see the IBM Informix: Guide to SQL Syntax.

Usage

When you use the CREATE EXTERNAL TABLE statement to send data to an external table, the data is only extracted from a level-0 archive. Logical logs are not rolled forward on an external table.

You can specify either of the following formats for external files:

DELIMITED: ASCII delimited file. This is the default format.
INFORMIX: internal binary representation. To optimize performance, filters are not applied to external tables. If filters exist, a warning indicates that they will be ignored.

For an example of using the CREATE EXTERNAL TABLE statement, see Restoring to an External Table.