NLS Issue with Orcale Enterprise stage

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
ray.wurlod
Participant
Posts: 54595
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:
Contact ray.wurlod

Post by ray.wurlod »

Set up NLS_LANG in dsenv or in the Administrator client if you want different per-project settings.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Top
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Re: NLS Issue with Orcale Enterprise stage

Post by chulett »

sumesh.abraham wrote:I strongly believe that the NLS Settings for Oracle and DataStage should be in sync.

Not necessarily. Only do this is you are sure the incoming data is appropriate for the NLS setting of the database. Setting them to be the same will mean no conversion is done during the load which could lead to 'corruption' in your Oracle data.
-craig

"You can never have too many knives" -- Logan Nine Fingers
Top
Post Reply

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