Handling NLS data is bit tricky.
Troubleshooting depends on the database involved and OS.
If ODBC stages are used, check following.
Check IANAAppCodePage value in odbc.ini
Use wide character types wherever possible
Hope this helps.
Search found 2 matches
- Mon Oct 31, 2016 8:21 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Chinese Char /UTF-8
- Replies: 6
- Views: 6199
- Mon Oct 31, 2016 8:03 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: ODBC Connector Timestamp issue
- Replies: 1
- Views: 2364
Re: ODBC Connector Timestamp issue
Try Using custom format string:
"%yyyy-%mm-%dd %hh:%mm:%ss.3"
Good luck !!
"%yyyy-%mm-%dd %hh:%mm:%ss.3"
Good luck !!