Saturday, October 20, 2012

Sybase IQ Table load


LOAD TABLE lineitem
(
l_orderkey BINARY WITH NULL BYTE,l_partkey BINARY WITH NULL BYTE,
l_suppkey BINARY WITH NULL BYTE,l_linenumber BINARY WITH NULL BYTE,
l_quantity BINARY WITH NULL BYTE,l_extendedprice BINARY WITH NULL BYTE,
l_discount BINARY WITH NULL BYTE,l_tax BINARY WITH NULL BYTE,
l_returnflag BINARY WITH NULL BYTE,l_linestatus BINARY WITH NULL BYTE,
l_shipdate BINARY WITH NULL BYTE,l_commitdate BINARY WITH NULL BYTE,
l_receiptdate BINARY WITH NULL BYTE,l_shipinstruct BINARY WITH NULL BYTE,
l_shipmode BINARY WITH NULL BYTE,l_comment BINARY WITH NULL BYTE
)

FROM 'C:\\mydata\\lineitem_binary.inp'

FORMAT BINARY
STRIP OFF
QUOTES OFF
ESCAPES OFF
PREVIEW ON
BYTE ORDER HIGH;

COMMIT

1 comment: