Re: simple questions-cannot find answers in common books

I too have only used matching indicators one, many years ago, but my
recollection of these is that the program would continue reading from each
file until the key in BOTH changed, thus, detail records which had no header
records in the related file, for example, would still be returned to the
program, as would header records with no detail, the presece of either, or
both, being indicated by the assigned file indicator being on or off.. How
you choose to handle this within your program is, of course, up to you. This
provides functionality which (to the best of my knowledge) still isn't
available in SQL, i.e. an outer join (if thats the right way of phrasing it
- I'm not an SQL guru), rather than the normal two statements, one left join
and one right join, then some horrible code to stick the extracted data
together. The downside I seem to recall is that it only works with the RPG
cycle. Is my recollection correct - or not?!

P


At 22:56 19/12/98 PST, you wrote:
>
>
>in rpg programming
>
>1.in form type I what is the use of SEQUENCE  eg.AA etc
>
>2.how are indicators U0-U9,MR used.
>
>3.is there any way i can try out RPG programs using internet ie 
>downloading or etc.
>
>4.can a subfile be used to access data from different physical files if 
>so how can an update pgm work on different physical files. 
>
>______________________________________________________
>Get Your Private, Free Email at http://www.hotmail.com
>* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
>* This is the RPG/400 Discussion Mailing List!  To submit a new         *
>* message, send your mail to "RPG400-L@midrange.com".  To unsubscribe   *
>* from this list send email to MAJORDOMO@midrange.com and specify       *
>* 'unsubscribe RPG400-L' in the body of your message.  Questions should *
>* be directed to the list owner / operator: david@midrange.com          *
>* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
>
>

* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
* This is the RPG/400 Discussion Mailing List!  To submit a new         *
* message, send your mail to "RPG400-L@midrange.com".  To unsubscribe   *
* from this list send email to MAJORDOMO@midrange.com and specify       *
* 'unsubscribe RPG400-L' in the body of your message.  Questions should *
* be directed to the list owner / operator: david@midrange.com          *
* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *