Re: SQL in RPGIV Error Message

[R Bruce Hoffman <bruce.hoffman@xxxxxxxxxxxxxxxxx>]

a left outer or right outer join will return nulls... that's what you
are asking for. If the file on the right in a left outer join has no
match... you get nulls for any of the fields made available from the
right file.


On Fri, 2004-04-30 at 07:33, Justin Houchin wrote:
> FROM M3P, PMP, ISP, O6PWO                                          
> LEFT JOIN WFP ON (WFP.WFSEGN = 'D.COLOR') AND                      
>                  (WFP.WFORD# = O6PWO.O6ORD#) AND                   
>                  (WFP.WFSUFX = O6PWO.O6SUFX) AND                   
>                  (WFP.WFITEM = O6PWO.O6ITEM)                       
> WHERE (M3P.M3PN=PMP.PMPART) AND                                    
> (CHAR(M3P.M3ON) = O6PWO.O6WO#) AND                                 
> (M3P.M3PN = ISP.ISPART) AND                                        
> ((O6PWO.O6ORD# = 1023 AND O6PWO.O6SUFX=0) OR                       
> (O6PWO.O6ORD# = 1025 AND O6PWO.O6SUFX = 0)) AND                    
> ISP.ISWH = M3P.M3WH                                                
> GROUP BY PMP.PMPART, M3P.M3WH, ISP.ISITYP, PMP.PMDESC, WFP.WFVAL   
> ORDER BY M3P.M3WH, ISP.ISITYP,PMP.PMPART
> 
> The program worked fine until I added the 4 lines of SQL statement to 
> left join the WFP file.  Also the above statement works correctly using 
> the interactive SQL utility (STRSQL).  I have a feeling the problem has 
> to do with the LnPackShp variable receiveing a null value, but I am not 
> for sure and do not know how to correct the problem. Any help would much 
> be appreciated.