Re: RPGLESQL interim processing file

[Nathan Andelin <nandelin@xxxxxxxxx>]

We like to encapsulate SQL statements into VIEWS. When you create say
VIEW_2 by selecting from say VIEW_1, I don't know if there is a proper name
for that. I like to say cascading views. This technique can greatly
simplify SQL statements and gives you some control over how the query
engine runs.



On Mon, Mar 25, 2019 at 1:49 PM Booth Martin <booth@xxxxxxxxxxxx> wrote:

> I am asking the wrong question because I don't know enough to frame the
> question correctly.
>
> I have an sql situation which is too complicated for me to grasp all of
> one piece.  I would like to do half the process into a smaller file, and
> then complete the process on that smaller file.
>
> What I am thinking is process A which gathers 12 or so fields from 3
> very large files and then processes B through G which expand, group
> and/or orders those fields in various ways, as needed for various web
> services.
>
> I realize I can create a file in QTEMP and then draw from that, but it
> occurs to me that I must not be the first to have this problem; maybe I
> should stop, look, and listen.  SQL has surprised me before and no doubt
> will again.
>
>
> --
> This is the RPG programming on IBM i (RPG400-L) mailing list
> To post a message email: RPG400-L@xxxxxxxxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: https://lists.midrange.com/mailman/listinfo/rpg400-l
> or email: RPG400-L-request@xxxxxxxxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at https://archive.midrange.com/rpg400-l.
>
> Please contact support@xxxxxxxxxxxx for any subscription related
> questions.
>
> Help support midrange.com by shopping at amazon.com with our affiliate
> link: https://amazon.midrange.com