Page 1 of 1

Posted: Mon Dec 23, 2013 8:58 am
by chulett
So is this actually a Server job or a Parallel job? Since you mentioned EReplace (and we're in the Server forum) I suspect the former but you marked the Job Type as Parallel and could be in the 9.x world. And it would seem you don't have a stored procedure call issue, just an NLS translation one.

So, is your installation NLS enabled? What charactersets are you dealing with, source and target? There is no bad data, only misunderstood data so the goal of those questions is to get the data loaded properly rather than nuked.

Posted: Mon Dec 23, 2013 11:16 am
by chulett
No problem, here we are in the proper forum.

Can you answer the NLS and characterset questions, please? And clarify the exact version of DataStage you are running. Thanks.

Posted: Tue Dec 24, 2013 1:30 am
by danielryan
datastage 9.1
NLS setting is:MS1252-CS