Parses fixed-width fields and automatically converts them to the given SQL types.


FIXED_COLUMN_LOG_PARSE ( <string value expression>, <column description string expression> )
<column description string expression> := '<column description> [,...]'
<column description> :=
<identifier> TYPE <data type> [ NOT NULL ]
START <numeric value expression> [FOR <numeric constant expression>]


Parsing of binary files is not supported.

Starting position of column is 0. Column specifications for types DATE,TIME and TIMESTAMP support a format parameter allowing the user to specify exact time component layout. The parser uses the Java class to parse the strings for types DATE, TIME and TIMESTAMP. The Date and Time Patterns topic gives a full description and examples of timestamp format strings. The following is an example of a column definition with a format string:

"name" TYPE TIMESTAMP 'dd/MMM/yyyy:HH:mm:ss'

See also the REGEX_LOG_PARSE and similar topics in this guide.