Store procedure call doesnt work

Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.

Moderators: chulett, rschirm, roy

Post Reply
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post 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.
-craig

"You can never have too many knives" -- Logan Nine Fingers
Top
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post 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.
-craig

"You can never have too many knives" -- Logan Nine Fingers
Top
danielryan
Participant
Posts: 3
Joined: Mon Dec 23, 2013 5:53 am
Location: Alpharetta

Post by danielryan »

datastage 9.1
NLS setting is:MS1252-CS
Top
Post Reply

Return to “IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)”