Hi nsg,
I have come across the same problem as shown in this post.
Could you please provide the trnasformation logic used by you
Junk Characters in DataStage
Moderators: chulett, rschirm, roy
Junk Characters in DataStage
Thanks,
HK
*Go GREEN..Save Earth*
HK
*Go GREEN..Save Earth*
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.
Regards,
Deepak Singhal
Everything is okay in the end. If it's not okay, then it's not the end.
Deepak Singhal
Everything is okay in the end. If it's not okay, then it's not the end.
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...
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers
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
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
Thanks,
HK
*Go GREEN..Save Earth*
HK
*Go GREEN..Save Earth*
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.
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers