load data
infile 'orders.tbl' "str'\n'"
append
into table ORDERS
fields terminated by '|'
trailing nullcols
(O_ORDERKEY CHAR(4000),
O_CUSTKEY CHAR(4000),
O_ORDERSTATUS CHAR(4000),
O_TOTALPRICE DECIMAL EXTERNAL"TO\_NUMBER(:O\_TOTALPRICE,'99999999.99')",
O_ORDERDATE DATE "YYYY-MM-DD",
O_ORDERPRIORITY CHAR(4000),
O_CLERK CHAR(4000),
O_SHIPPRIORITY CHAR(4000),
O_COMMENT CHAR(4000)
)