Hi All,
So far, I've been extracting data from db2 tables and exporting the file as a tab delimited file into a UNIX server using the following command:
export to /.../.../.../.../.../SM_RAW_DATA.dat of del modified by coldel| nochardel
select a.accno,
a.CUR_BL_AM,
a.lst_pdue_dt,
a.min_pmt_due_am as Min_Pay,
b.LST_PMT_AM ,
a.PMT_DUE_DT,
a.adg_cd,a.adg_strt_dt,
a.adg_end_dt,
...
By default, these values are going in as tab-delimited.
Now, I need to write the data in to a fixed length file.
Kindly, provide me with the syntax as soon as possible!