Topic
3 replies Latest Post - ‏2012-12-26T13:27:00Z by sbjerry
sbjerry
sbjerry
23 Posts
ACCEPTED ANSWER

Pinned topic Problem when processing data in DB2 of AS400

‏2012-12-26T03:09:53Z |
Env:

Source: AS400 DB2 6.1
Target: AS400 DB2 6.1

The field type is Character, but not Character-o, content contains Chinese Chracters

If
Optim directory db and db which hosts remote table from source db are both UTF-8. Extract, convert, Insert can be processed. But browsing extracted file, Chinese characters shows as unreadable codes。 And in AS400, the inserted Chinese Chracters shows as block diagram

If
Optim directory db and db which hosts remote table from source db are both GBK, Extract, convert can be processed, browsing extracted file, Chinese characters shows as expected. BUT, the extracted files cannot be inserted into Target table

gives out:
ICU error converting from Multibyte into Unicode (as UChar) using db2luw-1386, reason 12 = U_ILLEGAL_CHAR_FOUND
Updated on 2012-12-26T13:27:00Z at 2012-12-26T13:27:00Z by sbjerry
  • sbjerry
    sbjerry
    23 Posts
    ACCEPTED ANSWER

    Re: Problem when processing data in DB2 of AS400

    ‏2012-12-26T03:11:53Z  in response to sbjerry
    Some supplement, Optim V8.1 FP4 in Windows2003
    • sbjerry
      sbjerry
      23 Posts
      ACCEPTED ANSWER

      Re: Problem when processing data in DB2 of AS400

      ‏2012-12-26T03:16:36Z  in response to sbjerry
      Another question is that, when the optim directory db and db hosts remote table are both 1386, and source and target db on AS400, when insert, why it convert 1386 to Unicode?
  • sbjerry
    sbjerry
    23 Posts
    ACCEPTED ANSWER

    Re: Problem when processing data in DB2 of AS400

    ‏2012-12-26T13:27:00Z  in response to sbjerry
    Nobody knows?