Outer Join Query?



IBM's flagship relational database management system

Re: Outer Join Query?

Postby dick scherrer » Sat May 09, 2009 12:44 am

Hello,

Cheking with HEX ON, i found that they were null charecters.
There is no such thing as a "null character". . . The Null Indicator might be set, but no value from x'00' to x'FF' is a null value - every value is valid as data. . .

You still have not posted some data in HEX with the "Code" tag. . .
Hope this helps,
d.sch.
User avatar
dick scherrer
Global moderator
 
Posts: 6268
Joined: Sat Jun 09, 2007 8:58 am
Has thanked: 3 times
Been thanked: 93 times

Re: Outer Join Query?

Postby GuyC » Tue Aug 11, 2009 5:13 pm

With a left outer join it is possible that some columns are null, even when defined not null in the table.

Hence dsntiaul will generate place for those null indicators
I can explain it to you, but i can not understand it for you.
GuyC
 
Posts: 315
Joined: Tue Aug 11, 2009 3:23 pm
Has thanked: 1 time
Been thanked: 4 times

Previous

Return to DB2

 


  • Related topics
    Replies
    Views
    Last post