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

    Unanswered: DB2 data (chinese char) loading issue

    Hello All,

    DB2 db version- 9.5/9.7 on Windows 2008 Server.

    We are trying to load data in DB2 database from SAS 9.2. This data contain
    unicoding like chinies, japanies etc characters. When we run the job,
    following error is occuring

    ERROR: CLI execute error: [IBM][CLI Driver][DB2/NT64] SQL0302N The value of
    a host variable in the EXECUTE or OPEN statement is out of range for its
    corresponding use. SQLSTATE=22001 NOTE: Statements not processed because of
    errors noted above.

    Note- This error will not occur if we remove all uncoding characters.

    db cfg parameters for this database:
    Database territory = US
    Database code page = 1208
    Database code set = UTF-8
    Database country/region code = 1

    Please guide me what should be the changes at DB2 side in order to
    successfully insert Chinese, Japanese characters.

    Thanking you all in advance.

    Regards,
    Vikas

  2. #2
    Join Date
    Jun 2003
    Location
    Toronto, Canada
    Posts
    5,516
    Provided Answers: 1
    Character column lengths in DB2 are specified in bytes, not characters. UTF-8 characters can occupy anywhere from 1 to 4 bytes.

  3. #3
    Join Date
    Dec 2010
    Posts
    2

    DB2 data (chinese char) loading issue

    Thank you for your reply but that does not help me solving my issue....

    Regards,
    Vikas:

Tags for this Thread

Posting Permissions

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