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 (area_srno , area_name , ngfid position (1) terminated by ';', filler1 boundfiller terminated by ';', filler2 boundfiller terminated by whitespace, parent "ltrim (:parent, 'PARENT;')", child "ltrim (:child, 'CHILD;')", tablename ":filler2 || '_' || :filler1") into table poles_7 when (filler1 = '7') and (filler2 = 'POLES') FIELDS TERMINATED BY X'9' trailing nullcols (area_srno , area_name , ngfid position (1) terminated by ';', filler1 boundfiller terminated by ';', filler2 boundfiller , filler3 filler , filler4 filler ) into table support_8 when (filler1 = '8') and (filler2 = 'SUPPORT') FIELDS TERMINATED BY X'9' trailing nullcols (area_srno , area_name , ngfid position (1) terminated by ';', filler1 boundfiller terminated by ';', filler2 boundfiller , filler3 filler , filler4 filler)