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.


1  CREATE EXTERNAL TABLE name  ( + , column data_type )  USING ( “filename“?  ,
2.1 DELIMITED
2.1 INFORMIX ) ;
Element Description
column The name of the column. Must conform to SQL identifier syntax rules. For more information, see the HCL OneDB™ Guide to SQL: Syntax.
data_type The built-in data type of the column. For more information about data types, see the HCL OneDB 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 before 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 HCL OneDB 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 are ignored.

For an example of using the CREATE EXTERNAL TABLE statement, see Restore to an external table.