Problem in char field in two environments.

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
DINAKAR
Participant
Posts: 8
Joined: Fri Aug 08, 2008 11:45 am
Location: pune

Problem in char field in two environments.

Post by DINAKAR »

Hello,

I am running same job in 2 diff env Dev and SIT,

Job reads input binary seq file and land to dataset. field is of char(40) data type... when I ran a job in Dev, this field is populated value with "ABC XYZ!" where as when I ran same job in SIT it shows "ABC XYZ]" so "!" is converted to "]".... I am not able to figure out what problem is... Is there any project level setting for this.

appreciate your resposnse.
Thanks
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

That's an odd 'conversion'. Is your installation NLS enabled? What is your default characterset in both environments?
-craig

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