Not able to read high values

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: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

Tell us a bit more about the Sequential File stage - in particular whether you have NLS enabled and, if so, which character map is being specified.

The "?"character typically indicates a character that cannot be mapped using the currently selected character map. The solution would be to choose a map that does allow this character to be mapped (to a Unicode code point).
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

That character is not covered by ASCII, even extended ASCII. Therefore you would need NLS enabled, and to use a map that handles the character - perhaps ISO8859-15.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
boxtoby
Premium Member
Premium Member
Posts: 138
Joined: Mon Mar 13, 2006 5:11 pm
Location: UK

Post by boxtoby »

Bear in mind that NLS works at "two levels".

You need to have an NLS code page enabled in the dsenv file for view data to work as well as in the project/job.

If you only define NLS in the project/job the data may well get transferred correctly but you won't be able to see it unless you load it in to a database and view the table from database IDE.

Hope that helps.

Bob
Bob Oxtoby
Post Reply