How are NULL values stored in Hash files?
Moderators: chulett, rschirm, roy
-
- Premium Member
- Posts: 730
- Joined: Tue Nov 04, 2008 10:14 am
- Location: Bangalore
How are NULL values stored in Hash files?
How are NULL values stored in Hash files?
A NULL (0x00) can be stored, as can an SQL NULL (0x80). Both are stored as-is in hashed files.
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>
-
- Premium Member
- Posts: 730
- Joined: Tue Nov 04, 2008 10:14 am
- Location: Bangalore
No, @NULL represents only one value, namely 0x00. DataStage server/BASIC has no concept of the SQL NULL value, but can represent its ASCII value.
<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:
0x00 is not @NULL. It is the ASCII NUL byte and can be represented using the function Char(0).
0x80 is @NULL (unless changed, on Windows platforms, because Microsoft uses 0x80 for the Euro symbol). The change is effected in uvconfig.
0x80 is @NULL (unless changed, on Windows platforms, because Microsoft uses 0x80 for the Euro symbol). The change is effected in uvconfig.
Last edited by ray.wurlod on Wed Feb 10, 2010 5:47 pm, edited 2 times in total.
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.
I was too slow today and not thinking! Thanks for correcting that Ray.
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>