Accented e issue in Windows DS8.7 Server jobs

Post questions here relative to DataStage Server Edition for such areas as Server job design, DS Basic, Routines, Job Sequences, etc.

Moderators: chulett, rschirm, roy

Post Reply
satkolli
Participant
Posts: 14
Joined: Thu Jun 05, 2008 12:26 pm

Re: Accented e issue in Windows DS8.7 Server jobs

Post by satkolli »

Does anyone have any insight into this issue? Thanks.
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

What's the characterset of your source DB2 instance?
-craig

"You can never have too many knives" -- Logan Nine Fingers
satkolli
Participant
Posts: 14
Joined: Thu Jun 05, 2008 12:26 pm

Post by satkolli »

This is a client DB2 database that I do not have the answer for. I am assuming it is UTF-8 since that is what they recommended I use when creating the XML.
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

Not the best place to be making assumptions, it has to be specified correctly so any conversion can be made properly. And they probably recommended UTF-8 for the XML as that's the XML standard. Rather than continue to guess, why not simply ask them? That answer will go a long way towards getting you a solution.
-craig

"You can never have too many knives" -- Logan Nine Fingers
satkolli
Participant
Posts: 14
Joined: Thu Jun 05, 2008 12:26 pm

Post by satkolli »

I sent out the question to them the moment you asked it. Not the most responsive. Am still waiting for a reply. Will let you know once I hear back. Thanks.
satkolli
Participant
Posts: 14
Joined: Thu Jun 05, 2008 12:26 pm

Post by satkolli »

So looks like my contact is unable to establish/find the characterset of the DB2 installed on the AS400. Any ideas or workarounds we could use... keeping in mind we cannot modify the DB.
satkolli
Participant
Posts: 14
Joined: Thu Jun 05, 2008 12:26 pm

Post by satkolli »

Anyone with ideas of how we can workaround this issue? Thanks.
Post Reply