CTL File Example (PO Conversion)

options (skip=1)
LOAD DATA
INFILE '$XBOL_TOP/bin/xxalv_po_conv.csv'
BADFILE '$XBOL_TOP/bin/xxalv_po_conv.bad'
REPLACE
INTO TABLE bolinf.xxalv_po_legacy_data
FIELDS TERMINATED BY "," optionally enclosed by '"' trailing nullcols
(po_group "TRIM(:po_group)",
po_num "TRIM(:po_num)",
line_type "TRIM(:line_type)",
vendor_num "TRIM(:vendor_num)",
vendor_suffix "TRIM(:vendor_suffix)",
buyr "TRIM(:buyr)",
creation_date "TRIM(:creation_date)",
ctry "TRIM(:ctry)",
pp_cl "TRIM(:pp_cl)",
trms "TRIM(:trms)",
sh_to "TRIM(:sh_to)",
byr_note "TRIM(:byr_note)",
conf_no "TRIM(:conf_no)",
conf_name "TRIM(:conf_name)",
fobc "TRIM(:fobc)",
sh_via "TRIM(:sh_via)",
ctg "TRIM(:ctg)",
nu1 "TRIM(:nu1)",
sh_via_name "TRIM(:sh_via_name)",
note1 "TRIM(:note1)",
note2 "TRIM(:note2)",
note3 "TRIM(:note3)",
note4 "TRIM(:note4)",
hdr_sts "TRIM(:hdr_sts)",
sts_date "TRIM(:sts_date)",
co_rc "TRIM(:co_rc)",
co_no,
co_date "TRIM(:co_date)",
line_no,
order_qty,
unit_price,
part "TRIM(:part)",
lin_cmt "TRIM(:lin_cmt)",
nu2 "TRIM(:nu2)",
req_no "TRIM(:req_no)",
req_date "TRIM(:req_date)",
equipment_no "TRIM(:equipment_no)",
account "TRIM(:account)",
dept "TRIM(:dept)",
operation "TRIM(:operation)",
mfg_part "TRIM(:mfg_part)",
recd_qty,
recd_date "TRIM(:recd_date)",
line_sts "TRIM(:line_sts)",
line_sts_date "TRIM(:line_sts_date)",
co_ct "TRIM(:co_ct)",
deliver_to "TRIM(:deliver_to)",
invoice_qty,
invoice_date "TRIM(:invoice_date)",
txbl "TRIM(:txbl)",
invoice_amt,
ext_dsc "TRIM(:ext_dsc)",
multi "TRIM(:multi)",
comp "TRIM(:comp)",
wrk_ord "TRIM(:wrk_ord)",
uom_code "TRIM(:uom_code)",
opn_clo "TRIM(:opn_clo)",
opn_rcv "TRIM(:opn_rcv)",
opn_inv "TRIM(:opn_inv)",
opn_today "TRIM(:opn_today)",
rcv_today "TRIM(:rcv_today)",
nu3 "TRIM(:nu3)",
nu4 "TRIM(:nu4)",
nu5 "TRIM(:nu5)",
nu6 "TRIM(:nu6)",
nu7 "TRIM(:nu7)",
vendor_name "TRIM(:vendor_name)",
buyer_name "TRIM(:buyer_name)",
need_date "TRIM(:need_date)",
country_name "TRIM(:country_name)",
freight_term "TRIM(:freight_term)",
ship_to "TRIM(:ship_to)",
fob_name "TRIM(:fob_name)",
ship_via "TRIM(:ship_via)",
change_order "TRIM(:change_order)",
payment_term "TRIM(:payment_term)",
po_status "TRIM(:po_status)",
cap_proj_no "TRIM(:cap_proj_no)",
item_description1 "TRIM(:item_description1)",
item_description2 "TRIM(:item_description2)",
special_instruction1 "TRIM(:special_instruction1)",
special_instruction2 "TRIM(:special_instruction2)",
special_instruction3 "TRIM(:special_instruction3)",
special_instruction4 "TRIM(:special_instruction4)",
line_ext_desc1 "TRIM(:line_ext_desc1)",
line_ext_desc2 "TRIM(:line_ext_desc2)",
line_ext_desc3 "TRIM(:line_ext_desc3)",
line_ext_desc4 "TRIM(:line_ext_desc4)",
line_ext_desc5 "TRIM(:line_ext_desc5)",
line_ext_desc6 "TRIM(:line_ext_desc6)",
open_qty "TRIM (:open_qty)")