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
-
xch2005
- Participant
- Posts: 85
- Joined: Fri Apr 29, 2005 3:13 am
- Location: India
Post
by xch2005 »
Hi,
Could not load string with special char. into Oracle table from Sybase.
eg. Histoire d’Or (value from Sybase) when loaded into Oracle it is with inverted question marks as it is umapped.
Oracle characterset - WE8ISO8859P1
Sybase characterset - ISO 8859-1 (Latin-1) - Western European 8-bit character set.
Tried by manually overiding the $NLS_LANG but no luck.
Appreciate your help on this.
Thanks
-
chulett
- Charter Member
- Posts: 43085
- Joined: Tue Nov 12, 2002 4:34 pm
- Location: Denver, CO
Post
by chulett »
xch2005 wrote:Tried by manually overiding the $NLS_LANG but no luck.
How?
-craig
"You can never have too many knives" -- Logan Nine Fingers
-
xch2005
- Participant
- Posts: 85
- Joined: Fri Apr 29, 2005 3:13 am
- Location: India
Post
by xch2005 »
Had the NLS_LANG variable in the DS administrator (user-defined) and used the parameter in job and passed the characterset to it.
-
xch2005
- Participant
- Posts: 85
- Joined: Fri Apr 29, 2005 3:13 am
- Location: India
Post
by xch2005 »
Also the NLS is not installed
-
ray.wurlod
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
-
Contact:
Post
by ray.wurlod »
If NLS is not installed then all you can work with is ASCII.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
-
xch2005
- Participant
- Posts: 85
- Joined: Fri Apr 29, 2005 3:13 am
- Location: India
Post
by xch2005 »
Thanks Ray, since the columns are not business critical we are ignoring for now.