Enterprise Edition Home | Express Edition Home | Previous Page | Next Page   SQL Statements > CREATE EXTERNAL TABLE (XPS) >

Manipulating Data in Fixed Format Files

For files in FIXED format, you must declare the column name and the EXTERNAL item for each column to set the name and number of characters. For FIXED-format files, the only data type allowed is CHAR. You can use the keyword NULL to specify what string to interpret as a NULL value.

Column-Level Constraints

Use column-level constraints to limit the type of data that is allowed in a column. Constraints at the column level are limited to a single column. 

Read syntax diagramSkip visual syntax diagramColumn-Level Constraints:
 
|--+----------+--+---------------------------------+------------|
   '-NOT NULL-'  |                         (1)     |
                 '-CHECK--(--| Condition |-------)-'

Notes:
  1. See Condition
Enterprise Edition Home | Express Edition Home | [ Top of Page | Previous Page | Next Page | Contents | Index ]