Junk Characters in DataStage

harikhk · Post by **harikhk** » Tue Jun 04, 2013 6:41 pm

Hi nsg,
I have come across the same problem as shown in this post.
Could you please provide the trnasformation logic used by you

singhald · Post by **singhald** » Wed Jun 05, 2013 1:13 am

Try to use Unicode in column definition of the field which has these extended ascii char, then see if your out has same char after processing through job. after then you can covert the ascii of these char into spaces etc.

harikhk · Post by **harikhk** » Wed Jun 05, 2013 8:28 am

Hi Deepak,
I have tried using unicode extension but the resulti is same
When I view the data from datatstage I see the value as ???????? but extracting to a dataset and viewing the dataset the output is blank

Am I missing anything..The customer data is Spanish

chulett · Post by **chulett** » Wed Jun 05, 2013 10:05 am

The first thing you missed was starting your own post so the resolution of your issue can be tracked. I've split you out and linked back to the original thread. Add the missing details of your issue, we have no idea what your job design / source / target / NLS charactersets in play are...

harikhk · Post by **harikhk** » Wed Jun 05, 2013 10:32 am

Hi Craig,

I have posted my query here
viewtopic.php?t=150009
and later felt this thread on the similar lines.
Anyways below are few details
Extracting data from DB2 hosted on z/OS codepage is CCSID37
Loading to DB2 hosted on AIX codepage 1208 and codeset UTF-8
The database is of Spanish customer

Below is the problem summary....
While extarcting data from source DB2, the data when viewed from datatstage I see the characters ?????? displayed for a particular column.This column size is 8 characters .For example when viewed the data from the datstage using DB2 connector stage, if input value is only 6 characters U12345 then the output is viewed as U12345?? and if input is null then output is ???????? which is the output value is passed with these junk characters When I load this data into the target DB2 hosted on AIX the job gets aborted with the error SQLExecute reported: SQLSTATE = 22001: Native Error Code = -302: Msg = [IBM][CLI Driver][DB2/AIX64] SQL0302N The value of a host variable in the EXECUTE or OPEN statement is out of range for its corresponding use. SQLSTATE=22001

If possible you may please go through my original post viewtopic.php?t=150009

or even I am happy to continue on this thread.

Thanks for your time

chulett · Post by **chulett** » Wed Jun 05, 2013 10:37 am

Sorry, missed the fact that you started a new post as well as jumped on the old one. Anyone wanting to help should do so in your post on the subject as there's no need to two conversations. I'm locking this one.