So something like this ??
Code:LOAD DATA INFILE 'z:\PREVIOUS_ADDRESS.dat' TRUNCATE INTO TABLE PREVIOUS_ADDRESS (YOUR_COL POSITION(001:004) INTEGER EXTERNAL CASE WHEN :YOUR_COL = 9999 THEN 9999 ELSE 12*trunc(:YOUR_COL/100) + mod(:YOUR_COL,100) END, PA_INCOME POSITION(005:019) CHAR )




Reply With Quote