Re: SQL explained

["Raul A. Jager W." <raul@xxxxxxxxxx>]

Use "prefix" in your RPG programs...

Steve Landess wrote:

> > Rob wrote:
> >  For example some of the code presented is V5R3.  Prior to V5R3
> >  LEFT OUTER JOIN CUSTMAST USING (SLSPSN))
> > Would have had to be written as
> >  LEFT OUTER JOIN CUSTMAST ON SLSPSNF.SLSPSN = CUSTMAST.SLSPSN)
> > Now, many people might still have to use this method because (IMNSHO) 
> > of a
> > poor design standard of naming the fields differently.  Example
> >  LEFT OUTER JOIN CUSTMAST ON SLSPSNF.SLSLSP = CUSTMAST.CSSLSP)
>
>
> Rob - since when did it become a "best practice" to use the same field 
> name multiple files?
>
> I have alway been taught that it is NOT a best practice, particularly 
> since in RPG if the field names are the same, the buffer storage 
> occupied by the field is global, and by READing or CHAINing you could 
> accidently overlay the value of a field in one file with the value of 
> the same field in another file, causing unpredictable results.
>
> Care to explain your reasoning?
>
> Regards,
> Steve