options(skip=1)
load data
append
continueif next preserve (1:1) = x'09'
into table ngf_rec_link
FIELDS TERMINATED BY X'9'
TRAILING NULLCOLS
(ngfid position (1) terminated by ';',
filler1 boundfiller terminated by ';',
filler2 boundfiller ,
parent  "ltrim (:parent, 'PARENT;')",
child  "ltrim (:child, 'CHILD;')",
tablename char(100) ":filler2 || '_' || :filler1")
into table MDU_19
when (filler1 = '19') and (filler2 ='MDU')
FIELDS TERMINATED BY X'9'
TRAILING NULLCOLS
(ngfid position (1) terminated by ';',
filler1 boundfiller terminated by ';',
filler2 boundfiller ,
filler3 filler ,
filler4 filler ,
inputs char(500) "rtrim (ltrim (:inputs, 'inputs;'), ';')",
owner  "rtrim (ltrim (:owner, 'owner;'), ';')",
location  "rtrim (ltrim (:location, 'location;'), ';')",
type  "rtrim (ltrim (:type, 'type;'), ';')",
accumulated_length  "rtrim (ltrim (:accumulated_length, 'accumulated_length;'), ';')",
diagram_dwg_number "rtrim (ltrim (:diagram_dwg_number, 'diagram_dwg_number;'), ';')",
no_units  "rtrim (ltrim (:no_units, 'no_units;'), ';')",
work_order "rtrim (ltrim (:work_order, 'work_order;'), ';')",
wireless "rtrim (ltrim (:wireless, 'wireless;'), ';')",
voip_ready "rtrim (ltrim (:voip_ready, 'voip_ready;'), ';')")