Results 1 to 3 of 3
  1. #1
    Join Date
    Mar 2010
    Posts
    2

    Unanswered: how to read exported files?

    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...

  2. #2
    Join Date
    Jun 2003
    Location
    Toronto, Canada
    Posts
    5,516
    Provided Answers: 1
    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.
    ---
    "It does not work" is not a valid problem statement.

  3. #3
    Join Date
    Mar 2010
    Posts
    2
    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?

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •