Results 1 to 5 of 5
  1. #1
    Join Date
    Mar 2011
    Posts
    20

    Unanswered: DB2 UNLOAD CCSID Substitution Issue

    Hi

    We are trying to take an unload of the table ( defined CCSID UNICODE) . The output is expected to be in EBCDIC. As specified below we are using NOSUBS to avoid CCSID character substitution. However, it fails for greek accent character "`" X'79' with the below error.

    "`" is valid in CCSID 875.


    CCSID Substitution is attempted for field "fieldname" table CDMD0001.CDMSITR


    UNLOAD TABLESPACE CDMD0001.CDMSITR
    FROM TABLE CDMDBA.INVOICE_TEMP
    WHEN ( COUNTRY = X'373236')
    EBCDIC CCSID(0,875,875)
    NOSUBS NOPAD

    DB Details

    DB2 System: DBN1
    DB2 SQL ID: CDMSID
    Userid : CDMSID
    DB2 Schema: CDMSID
    DB2 Rel : 915

    Can anyone suggest what could be incorrect here. Please let me know if more details are needed.
    Attached Thumbnails Attached Thumbnails eg.bmp  

  2. #2
    Join Date
    Apr 2012
    Posts
    1,034
    Provided Answers: 18
    so what do you expect DB2 to do when finds a character in the source unicode database that does not have a match in EBCDIC ?

  3. #3
    Join Date
    Mar 2011
    Posts
    20
    Point is does have a match EBCDIC. As mentioned ` is X'79' in EBCDIC CCSID 875 . The behavior is unexpected

  4. #4
    Join Date
    Mar 2011
    Posts
    20
    Can anyone please point out what the issue could be ?

  5. #5
    Join Date
    Apr 2012
    Posts
    1,034
    Provided Answers: 18
    What is the full hex value of the character in the CCSID-UNICODE source table?
    (Or are you saying that it is x'0079' also?)

    If you set MAXERR to a high value (default is 1) does the same symptom apply to other characters ?

Posting Permissions

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