jrn

["MURALI DHAR" <nmuralidhar@xxxxxxxxxxxxxx>]

How the journalling differs frm triggers?
murail

On Sat, 26 Oct 2002 BrgttHsr@aol.com wrote :
> --
> [ Picked text/plain from multipart/alternative ]
> Hello Manoj,
>
> there are several possibilities to join 2 physical files in PF
>
> Select *
>     from  FILE1 a, FILE2  b
>     where  a.KeyFld1 = b.KeyFld1 and  a.KeyFld2=b.KeyFld2 ....
>         and a.cond1 = b.cond1
>
> or
>
> Select *
>     from File1 a join File2 b
>          on a.KeyFld1=b.KeyFld1 and a.KeyFld2 = b.KeyFld ...
>     where a.Cond1 = b.Cond1
>
> Depending on what you want you can use LEFT OUTER JOIN or
> EXCEPTION JOIN,
> too.
>
> Birgitta
> _______________________________________________
> This is the RPG programming on the AS400 / iSeries (RPG400-L)
> mailing list
> To post a message email: RPG400-L@midrange.com
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/cgi-bin/listinfo/rpg400-l
> or email: RPG400-L-request@midrange.com
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/rpg400-l.
__________________________________________________________
Give your Company an email address like
ravi @ ravi-exports.com.  Sign up for Rediffmail Pro today!
Know more. http://www.rediffmailpro.com/signup/