Search found 2 matches

by pjedson
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

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.
by pjedson
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 !!