control_file

::= [option_part]
load_data_part
into_table_part
fields
column list

option_part

::= OPTIONS (options)

options

::= option [, option]

option

::= [SKIP = int literal] [ERRORS = int literal]

load_data_part

::= LOAD [DATA] [characterset_specification]
[DATE date_mask]
[TIME time_mask]
[TIMESTAMP timestamp_mask]
[INFILE filename]
[PRESERVE BLANKS]

characterset_specification

::= CHARACTERSET { NOCONVERT |
NOCNV |
ANSI |
MSWINDOWS |
PCOEM |
IBMPC |
SCAND7BIT }

into_table_part

::= INTO TABLE tablename

fields

::= [FIELDS {termination | enclosure}]

termination

::= TERMINATED BY termination_char [[OPTIONALLY] enclosure]

termination_char

::= WHITESPACE | 'char' | "char" | hex literal

enclosure

::= ENCLOSED BY enclose_char [AND enclose_char]

enclose_char

::='char' | "char" | hex literal

hex_literal

::= X'hex byte string'

column_list

::= column [, column]

column

::= column name datatype spec
[POSITION (int literal {: | -} int literal)]
[DATE date mask]
[TIME time mask]
[TIMESTAMP timestamp mask]
[NULLIF BLANKS | NULLIF NULLSTR| NULLIF 'string' | NULLIF ((int literal {: | -} int literal) = 'string')]

datatype_spec

::= {BINARY | CHAR [(length) ] | DATE |
DECIMAL [(precision [ , scale ])] |
DOUBLE [PRECISION] | FLOAT [(precision)] | INTEGER |
LONG VARBINARY | LONG VARCHAR |
NUMERIC [( precision[,scale ])] |
REAL | SMALLINT | TIME |
TIMESTAMP [ ( timestamp precisionv ) ] |
TINYINT | VARBINARY | VARCHAR [ (length ) ] }