Orders ctl

From Oramosswiki

load data
into table orders
append
fields terminated by '|'
optionally enclosed by '"'
trailing nullcols
(
 o_orderkey 
,o_custkey 
,o_orderstatus 
,o_totalprice 
,o_orderdate DATE "YYYY-MM-DD"
,o_orderpriority 
,o_clerk 
,o_shippriority 
,o_comment 
)