Re: Text Data File

Unload from Informix using dbaccess (unload to file select * from table),feed the unloaded data to an awk script which you must write. The awk script will do whatever you want with the day, slice, dice, mince, etc. Send me email if you want suggestions about the awk script. Ahmad Ramzi Salleh wrote: > Hello, > > What is the best way to get a text data file form Informix database so > that the output has a fixed column length i.e column 1 - 5 for > office_code, column 6 - 25 for office_desc, column 26 - 27 for > office_type etc.... > I also need to eliminate any delimiter and blank rows. > > Thank you in advanced.