load data
infile '/tmp/tpc/ship_mode.dat'
into table ship_mode
fields terminated by '|'
( SM_SHIP_MODE_SK,SM_SHIP_MODE_ID,SM_TYPE,SM_CODE,SM_CARRIER,SM_CONTRACT )