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.
Column DefinitionUse the column definition segment of the CREATE EXTERNAL TABLE statement to declare the name and data type of a single column of the new external table.
Using the EXTERNAL KeywordUse the EXTERNAL keyword to specify a CHAR data type for each column of your external table that has a data type different from the internal table.

Using the EXTERNAL Keyword

Use the EXTERNAL keyword to specify a CHAR data type for each column of your external table that has a data type different from the internal table.

For example, you might have a VARCHAR column in the internal table that you want to map to a CHAR column in the external table.

You must specify an external type for every column that is in fixed format. You cannot specify an external type for delimited format columns except for BYTE and TEXT columns where your specification is optional.