Issue with nChar in Datastage 11.3

ray.wurlod · Post by **ray.wurlod** » Fri Jun 12, 2015 2:42 am

Welcome aboard.

What are the NLS settings for this stage/job?

ravigoud87 · Post by **ravigoud87** » Fri Jun 12, 2015 3:22 pm

Hi,
1) we upgrdaed DS from 7.5 to 11.3
2) That job is a SERVER JOB in DS 7.5 and even in 11.3 its a SERVER JOB
3) we are connecting to ORACLE ( Inbound) using ODBC
4) NLS Settings - "Project default (UFT8)"

chulett · Post by **chulett** » Fri Jun 12, 2015 5:35 pm

Why is your Job Type set to Parallel? I'm going to fix that in your first post and move this to the proper forum.

ravigoud87 · Post by **ravigoud87** » Mon Jun 15, 2015 11:18 am

Sure..... any one has any idea of this issue ?

ray.wurlod · Post by **ray.wurlod** » Mon Jun 15, 2015 6:27 pm

There's obviously some kind of problem with the data in the NEW_STATUS field.

Apart from the mismatched quote, the hex representation looks OK (all of the byte representations are below 256).

What do you see for this value when you select directly from Oracle, for example using TOAD?