Results 1 to 6 of 6
  1. #1
    Join Date
    May 2003
    Posts
    4

    Unanswered: UNICODE to EBCDIC and back ...

    I have been trying to unload a DB2 database (V7R1) that is encoded in UNICODE into EBCDIC formatted unload files.
    When doing that I have the character sets parameter set-up as EBCDIC CCSID(37,37,37) using 37 for the single, mixed and double character sets.
    The unload works fine.

    But when I try to re-load the database from these EBCDIC files with the character sets specified as UNICODE CCSID(367,1208,1200) the DB2 load utility abends on a french accented characters with DSNU334I - ERROR CODE '19'

    Any suggestions?

  2. #2
    Join Date
    May 2003
    Posts
    113

    Re: UNICODE to EBCDIC and back ...

    your EBCDIC ccsid are wrong. It should be (37,1140,0). That is
    there is not DBCS ccsid for this set.

    Originally posted by bisd
    I have been trying to unload a DB2 database (V7R1) that is encoded in UNICODE into EBCDIC formatted unload files.
    When doing that I have the character sets parameter set-up as EBCDIC CCSID(37,37,37) using 37 for the single, mixed and double character sets.
    The unload works fine.

    But when I try to re-load the database from these EBCDIC files with the character sets specified as UNICODE CCSID(367,1208,1200) the DB2 load utility abends on a french accented characters with DSNU334I - ERROR CODE '19'

    Any suggestions?

  3. #3
    Join Date
    May 2003
    Posts
    4

    Re: UNICODE to EBCDIC and back ...

    Thanks for the info - how did you arrive at this set of CCSID's?

  4. #4
    Join Date
    May 2003
    Posts
    113

    Re: UNICODE to EBCDIC and back ...

    Personally, I recently worked on ccsid conversion project about DB2.

    Actually, you can google with these keyword: db2 ebcdic ccsid 37

    Originally posted by bisd
    Thanks for the info - how did you arrive at this set of CCSID's?

  5. #5
    Join Date
    May 2003
    Posts
    4

    Re: UNICODE to EBCDIC and back ...

    From what I read, the only difference between 37 and 1140 is that 1140 supports the Euro symbol.

    1140 doesn't work for me anyway, the unload gives this message:

    DSNU1250I ; DSNUULIA - ERROR IN CCSID TRANSLATION FOR VERIFICATION, FROM CCSID 1208 TO 1140

  6. #6
    Join Date
    May 2003
    Posts
    113

    Re: UNICODE to EBCDIC and back ...

    You are probably right. I may miss understand the doc. If so, it should be (37,0,0).

    Originally posted by bisd
    From what I read, the only difference between 37 and 1140 is that 1140 supports the Euro symbol.

    1140 doesn't work for me anyway, the unload gives this message:

    DSNU1250I ; DSNUULIA - ERROR IN CCSID TRANSLATION FOR VERIFICATION, FROM CCSID 1208 TO 1140

Posting Permissions

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