ASCII to EBCDIC conversion involving Packed Decimal fields

ASCII to EBCDIC conversion involving Packed Decimal fields

1
NewbieNewbie
1

    Sep 08, 2006#1

    Hi,
    I tried looking through the forum to see if I can find something on this conversion, but I guess my issue is a bit extended than what has already been discussed on the conversion

    I am looking to convert ASCII based files into EBCDIC files. Also, the integer / decimal fields in ASCII needs to be converted to Packed Decimal (COMP-3) fields in the EBCDIC file..

    Any ideas?

    Thanks
    Prakash

    63
    Advanced UserAdvanced User
    63

      Re: ASCII to EBCDIC conversion involving Packed Decimal fiel

      Sep 11, 2006#2

      Hi Prakash

      I'm going to suggest you look at VEdit and Greenview Data.
      www.vedit.com
      &
      http://greenviewdata.com/ebcdic

      I know the iSeries (now System i) and some commands you can use.
      /*============================================*
      CPYFRMSTMF FROMSTMF('HOME/MYDIRECTORY/DATA.TXT')
      TOMBR('LIBARARY/DATAFILE') MBROPT(*REPLACE)
      /*============================================*

      but my favorite is
      /*============================================*
      CPYFRMIMPF FROMSTMF('/HOME/IFSdirectory/yourdata') TOFILE(yourDataLib/yourDataFile) RCDDLM(*CRLF) STRDLM('"') FLDDLM(*TAB)
      /*============================================*

      If I can, I use Excel to clean up the data a bit, that's why you see the
      Tab character, I used it as a field delimeter, not a comma.

      Hope this helps