urg: How to export data in a flat-file with comp-3 COBOL format?
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: urg: How to export data in a flat-file with comp-3 COBOL format?

  1. #1
    Join Date
    Oct 2002
    Posts
    1
    Please, someone can tell me how to export data in a flat-file with comp-3 COBOL format?

    I tried to spool in a file converting in a ebcdic character set by the CONVERT statement:

    select convert (1234,'WE8EBCDIC500','US7ASCII') from dual;

    but it return a string like x'F1F2F3F4' and not ina comp-3 format...

    tnx!

  2. #2
    Join Date
    Aug 2000
    Location
    Belgium
    Posts
    342
    It's just a piece of the puzzle,
    but you can convert from ascii to ebcdic using the unix dd command.

    dd ..... conv=ebcdic ...

    HTH
    Gert

Posting Permissions

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


Click Here to Expand Forum to Full Width