T. McQuinn
Member
I'm doing my first Left Outer Join in E1.
iSeries V6R1M0
E900, Tools Release 8.98.43
Screen shots of the join and data selection attached (hopefully).
Can anyone tell me why the generated SQL that I see in the debuglog also selects IBMCU = NULL?? I definitely don't want that and I'm just not getting this one.
FROM DVBDTA/F4101 T0 LEFT OUTER JOIN DVBDTA/F4102 T1
ON T0.IMITM = T1.IBITM
WHERE ( ( T0.IMGLPT IN ( 'AG01' ) OR ( T1.IBMCU = ' 6009000' OR T1.IBMCU IS NULL ) ) )
iSeries V6R1M0
E900, Tools Release 8.98.43
Screen shots of the join and data selection attached (hopefully).
Can anyone tell me why the generated SQL that I see in the debuglog also selects IBMCU = NULL?? I definitely don't want that and I'm just not getting this one.
FROM DVBDTA/F4101 T0 LEFT OUTER JOIN DVBDTA/F4102 T1
ON T0.IMITM = T1.IBITM
WHERE ( ( T0.IMGLPT IN ( 'AG01' ) OR ( T1.IBMCU = ' 6009000' OR T1.IBMCU IS NULL ) ) )