OCI_INVALID_HANDLE with NLS Mapping
Moderators: chulett, rschirm, roy
Re: OCI_INVALID_HANDLE with NLS Mapping
Just to be certain, how do you determine that the output isn't correct? Do not use the "view data" functionality to do this.userasif wrote:...If I use NONE for NLS Mapping for source stage then job finished is OK but data is not in Arabic form...
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>
Best use a tool which shows you the hex values for each character. "?" could be either a real question mark or it could mean an undisplayable character (using the session's NLS settings). What is the HEX or Decimal value of the first '?' character in the string?
<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:
Invalid handle usually indicates some kind of connectivity problem, rather than any kind of data problem.
That said, I will almost guarantee that you can not use a Russian map to move Arabic data.
Character maps do NOT perform translation!
That said, I will almost guarantee that you can not use a Russian map to move Arabic data.
Character maps do NOT perform translation!
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.
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>
As Ray has already stated, are you sure that your selected character sets are correct? Is the arabic data in your source perhaps already stored correctly and by trying to convert from Russian to Arabic you are actually corrrupting the data?
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>
Are you sure that your selected character sets are correct?
I am not sure about the Russian character set to be used in DataStage but I am using KOI8-R.
Also problem occurs with input stage NLS Mapping.
Is the arabic data in your source perhaps already stored correctly?
Yes, because the same source data display is in Arabic in Oracle Forms application.
I am not sure about the Russian character set to be used in DataStage but I am using KOI8-R.
Also problem occurs with input stage NLS Mapping.
Is the arabic data in your source perhaps already stored correctly?
Yes, because the same source data display is in Arabic in Oracle Forms application.
Since RU8PC866 does not contain mappings for arabic characters but you stated that they are visible in the source, you are essentially corrupting your data by mapping it from KOI8-R during your initial read. This stage needs to be told that the incoming data is already in AR8MSWIN1256
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>
I think you are trying too much at once. Reduce the problem to the read portion, just read the data and then write to a sequential file. Ensure you choose the right mapping for your source - once that works, you can add complexity.
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>
Remember that a "?" mark might be an undisplayable character, so you will need to produce the hex equivalent. Start with the source - what is the hex value of the first character. Then check the same character in the sequential file. If you maps are NONE then they will be identical. If both your source and target maps are arabic, the values should be the same as well.
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>