Pandora's Box - Using DS NLS
Moderators: chulett, rschirm, roy
Pandora's Box - Using DS NLS
I know that it used to be well-nigh to impossible to revert from a NLS installation to a non-NLS one. I wanted to ask if this has changed with the newer releases? Has anyone written a program that might take a .DSX or .XML export and remove NLS-information?
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
What happens when you try to import into a non-NLS DataStage a file exported from an NLS-enabled installation? Can you fiddle with the CharacterSet property in the file header?
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Ray,
I remember back when DS was young(er) the export contained so many NLS-related attributes that whenever we tried to "fiddle" with the files and import them into non-nls accounts the import would either fail or the jobs were unusable. I was wondering if the NLS-enabling of a DataStage account was still akin to the mathematical trapdoor algorithm or Pandora's box .... once you start you can never go back...
I remember back when DS was young(er) the export contained so many NLS-related attributes that whenever we tried to "fiddle" with the files and import them into non-nls accounts the import would either fail or the jobs were unusable. I was wondering if the NLS-enabling of a DataStage account was still akin to the mathematical trapdoor algorithm or Pandora's box .... once you start you can never go back...
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>
Sad to say I only worked with NLS enabled.
Roy R.
Time is money but when you don't have money time is all you can afford.
Search before posting:)
Join the DataStagers team effort at:
http://www.worldcommunitygrid.org
Time is money but when you don't have money time is all you can afford.
Search before posting:)
Join the DataStagers team effort at:
http://www.worldcommunitygrid.org
Were you working a UNIX environment and was it Server or Px? If it is that easy it would take a great load off my mind with our impeding conversion to NLS.battaliou wrote:I edited my uvconfig file (NLSMODE 0) to disable NLS in my current environment. I had to do a uvregen as well, but everything reverted ok.
Thanks for the info,
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
The reason that this works is that UV-UTF8 encodes Unicode code points in such a fashion that any single-byte characters (for example ASCII) are still stored as single-byte characters, except for those that use the same code points as dynamic array delimiters (248 through 255).
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Hello Arnd
Converting to NLS was very easy. The knock on effect only seemed to affect dates. For example a standard date in non nls looks something like 2005/02/25 whereas in NLS its 2005 02 25.
This issue affected some of our function calls.
Regards
Martin Battaliou
Converting to NLS was very easy. The knock on effect only seemed to affect dates. For example a standard date in non nls looks something like 2005/02/25 whereas in NLS its 2005 02 25.
Code: Select all
OCONV(DATE(),'DYMD[4,2,2]')
Regards
Martin Battaliou
3NF: Every non-key attribute must provide a fact about the key, the whole key, and nothing but the key. So help me Codd.
Battaliou,
I realize that the conventions will change depending on the locale you are in; but I am worried about how DS will input & output the varied character sets - Big5, Shift-JIS, etc. It also seems that Px deals with these conversions quite differently than Server does; so I've decided to leave the proverbial box closed and just state categorically that there is no way back from NLS. It might not be the complete truth but it will suffice.
Btw, why did you end up reverting?
Thanks for the input!
I realize that the conventions will change depending on the locale you are in; but I am worried about how DS will input & output the varied character sets - Big5, Shift-JIS, etc. It also seems that Px deals with these conversions quite differently than Server does; so I've decided to leave the proverbial box closed and just state categorically that there is no way back from NLS. It might not be the complete truth but it will suffice.
Btw, why did you end up reverting?
Thanks for the input!
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>