DSXchange

1) I viewed the data in the OS directly.. it showed me the expected value. 2) Yes the Database is UTF-8 3) Yes, it is the same database. Sure, I will change the DB2 Bulk to connector stage and see what happens. Incase, If i have to change the NLS settings.. what is preferred ? to handle this kind of...

ac

Hi Michale, i replaced the DB2 bulk stage with the sequential file in the load job and ran it. I was able to see the expected value in the sequential File.

it only gets converted when it is processed/loaded to the DB2 table through DB2 bulk stage.

Additional Information: we are migrating datastage jobs from version 7.5 to version 9.1 and we are doing a parallel testing.. to make sure the results generated by v7.5 jobs and v9.1 jobs are same. the same load job loads it correctly in the table from v7.5 but the issue is only when we load table t...

Hello Experts, Need your help to resolve this issue. My job design is like this Extract Job: DB2 table --> transformer ---> Dataset Load Job: Dataset --> transformer --> DB2 bulk stage in one of the source column, the value is like "602 - MBM OKLAHOMA CITY   02" and the same is passe...