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
chulett
Charter Member
Posts: 43085 Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO
Post
by chulett » Fri Jul 09, 2010 6:59 am
NLS enabled? Character set of the source? Character set of the target? What database?
-craig
"You can never have too many knives" -- Logan Nine Fingers
daramanoj
Participant
Posts: 20 Joined: Wed Jul 29, 2009 4:01 am
Post
by daramanoj » Fri Jul 09, 2010 7:12 am
Yeah I have enabled the NLS to UTF8 and i am using Oracle database
Thanks ,
Manoj
chulett
Charter Member
Posts: 43085 Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO
Post
by chulett » Fri Jul 09, 2010 7:41 am
Two of four questions answered.
-craig
"You can never have too many knives" -- Logan Nine Fingers
daramanoj
Participant
Posts: 20 Joined: Wed Jul 29, 2009 4:01 am
Post
by daramanoj » Fri Jul 09, 2010 9:00 am
cAN I KNOW ABOUT THE INPUT CHARECTER SET AND OUTPUT CHARECTER SET AND WHERE TO CHECK THEM IN MY DATASTAGE JOB
Thanks ,
Manoj
vivekgadwal
Premium Member
Posts: 457 Joined: Tue Sep 25, 2007 4:05 pm
Post
by vivekgadwal » Fri Jul 09, 2010 1:00 pm
daramanoj wrote: cAN I KNOW ABOUT THE INPUT CHARECTER SET AND OUTPUT CHARECTER SET AND WHERE TO CHECK THEM IN MY DATASTAGE JOB
You will know how DataStage is reading the file and writing to a DB within the stage window's NLS page. However, you will get a better idea if you check the actual source and target (on the OS side, may be...)
Vivek Gadwal
Experience is what you get when you didn't get what you wanted
ray.wurlod
Participant
Posts: 54607 Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:
Post
by ray.wurlod » Fri Jul 09, 2010 6:04 pm
In particular check the code page being used by the database(s). Compatible code sets (map names) must be used throughout.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.