Char data type not accepting "0" from table
Moderators: chulett, rschirm, roy
-
- Premium Member
- Posts: 353
- Joined: Wed Apr 06, 2005 8:45 am
Char data type not accepting "0" from table
hi,
I am extracting from Oracle 9.1 and loading SAP BW. One of the field is Char and the values are alpha numeric. My issue is DataStage is replacing zero with "?" . Doesnt DataStage accept "0"s in Char when extracting from tables.
Any idea would be apreciated!.
I am extracting from Oracle 9.1 and loading SAP BW. One of the field is Char and the values are alpha numeric. My issue is DataStage is replacing zero with "?" . Doesnt DataStage accept "0"s in Char when extracting from tables.
Any idea would be apreciated!.
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
DataStage does not have any problem with the character "0". I'd guess that you don't have this in your data. Use a hex editor to determine exactly what you do have. The ASCII code for "0" is 48 (which is 0x30).
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.
-
- Premium Member
- Posts: 353
- Joined: Wed Apr 06, 2005 8:45 am
Vinay,
the conversion might be working correctly but the ds view-data doesn't support nls on display and might be showing it incorrectly. Chances are high that the data is going into the Db correctly. Do you have an NLS project and if so, what are your in and out character sets. Are you writing to SAP via Idocs? Sequential files? BAPI?
the conversion might be working correctly but the ds view-data doesn't support nls on display and might be showing it incorrectly. Chances are high that the data is going into the Db correctly. Do you have an NLS project and if so, what are your in and out character sets. Are you writing to SAP via Idocs? Sequential files? BAPI?
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>
Vinay,
what are you using to look at the file? If you can open up another file of the same type (i.e. .txt) with the same tool and see words with umlaut then you have a conversion issue; but 9 times out of 10 the problem is not in the data but in the display method. I am an old-timer, so in cases like this I will almost always use the DataStage editor, since in the up-arrow mode it will show me the octal values of undisplayable characters.
what are you using to look at the file? If you can open up another file of the same type (i.e. .txt) with the same tool and see words with umlaut then you have a conversion issue; but 9 times out of 10 the problem is not in the data but in the display method. I am an old-timer, so in cases like this I will almost always use the DataStage editor, since in the up-arrow mode it will show me the octal values of undisplayable characters.
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>
-
- Premium Member
- Posts: 614
- Joined: Fri Feb 06, 2004 3:59 pm
Kollurianu,
from Unix or Windows one can enter the DataStage command line environment. If you search the forum I am sure you will see several posts with good descriptions; but it really isn't necessary to use this environment for most DataStage developers.
Entering commands from the Administrator essentially uses this interface; it does contain an editor that is line-oriented and quite archaic.. you enter command like p23 to print 23 lines, c/abc/234/g3 to change abc into 234 globally on 3 lines and so on. Only old dinosaurs who grew up with editors like this and still think that EMACS is the best thing since sliced bread will appreciate the ED datastage editor.
The NLS settings can be seen in several places. The uvconfig file and the NLS settings in the DataStage Administrator just to mention 2 of them.
I think that the Pfe (Programmer's file editor) in Windoze is not only shareware but performs just about any display permutation you would want.
from Unix or Windows one can enter the DataStage command line environment. If you search the forum I am sure you will see several posts with good descriptions; but it really isn't necessary to use this environment for most DataStage developers.
Entering commands from the Administrator essentially uses this interface; it does contain an editor that is line-oriented and quite archaic.. you enter command like p23 to print 23 lines, c/abc/234/g3 to change abc into 234 globally on 3 lines and so on. Only old dinosaurs who grew up with editors like this and still think that EMACS is the best thing since sliced bread will appreciate the ED datastage editor.
The NLS settings can be seen in several places. The uvconfig file and the NLS settings in the DataStage Administrator just to mention 2 of them.
I think that the Pfe (Programmer's file editor) in Windoze is not only shareware but performs just about any display permutation you would want.
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>
-
- Premium Member
- Posts: 614
- Joined: Fri Feb 06, 2004 3:59 pm
If you have NLS disabled then you do not have any NLS settings.
That makes life easier for you. Why are you worried about NLS settings? How did this thread drift so far from the original question? Why am I still here at the office?
That makes life easier for you. Why are you worried about NLS settings? How did this thread drift so far from the original question? Why am I still here at the office?
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>