NULL Data Conversions

Use the NULL conversion option to convert specific values in the input data to NULLs when inserting into SAP Sybase IQ column indexes.

You can use this option with any columns that allow NULLs. You can specify this conversion option with any SAP Sybase IQ data type.

This is the syntax:

NULL ({BLANKS | ZEROS | literal' ['literal']...})

where:

BLANKS indicates that blanks convert to NULLs.
ZEROS indicates that binary zeros convert to NULLs.
literal indicates that all occurrences of the specified literal convert to NULLs. The specified literal must match exactly, including leading and trailing blanks, with the value in the input file, for SAP Sybase IQ to recognize it as a match. You can list up to 20 literal values.

You may need to use additional conversion options on the same column. For example, to insert ASCII data into an INT column, which is stored in binary format, and convert blanks in the input data to NULLs when inserted, use the ASCII conversion option to convert the input to binary and the NULL conversion option to convert blanks to NULLs.

This is a Windows example:

LOAD TABLE lineitem(
    l_orderkey NULL(ZEROS) ASCII(4),
    l_partkey ASCII(3),
    l_shipdate date('MM/DD/YY'),
    l_suppkey ascii(5),
FILLER(1))
FROM 'C:\\MILL1\\tt.t'
PREVIEW ON