Anybody help ?

How can I translate export file with IXF format to DEL format or other regulate format file ? Because our source platform is AS400 with DB2 7.2 which can't export to DEL format file. And current system will not use DB2 database any more.

Thank you in advance...

Install DB2 Express-C, then import the IXF file and subsequently export it in the delimited format. Or, if you are into that kind of thing, you can write your own conversion utility - the IXF file format is documented in the manuals.

Appreciate your advice I am really a fresher in DB2 domain, not quite sure any simpler way to process this translation. at present, I try to redirect to query to Unix file. Unfortunately, I dunno how to specify the delimiter, as you know, query result always delimit by space, can I use another delimiter ?
By the way, we can use || to concatenate two column, but if one column = null, the whole record is null which is not allowed in requirement.
Any advice?