Re: Limits results of an SQL query

["Christopher A. Libby" <clibby@xxxxxxxxxxxxxxxxxxxxxx>]

I don't think this method would give me what I'm looking for, as the actual
query would use a multi-table join and grouping.

I use an INSERT INTO a temporary table, and then this method would work
fine...but I'm trying to stay away from this.

-Chris

----- Original Message -----
From: "Rolf Mittag" <mailing-lists@r-m-e-d-v.de>
To: <rpg400-l@midrange.com>
Sent: Tuesday, December 04, 2001 10:36 AM
Subject: RE: Limits results of an SQL query


> there's 2 things :
>
> first : you don't need the rrn in the column list
>
> second : use this technique with care. in most cases it's
> fairly useless since SQL tables are created with
>
> REUSEDLT(*YES)
>
> so if you have some kind of sorting in the result set you
> may not get what you expect
>
> Rolf
> _______________________________________________
> 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.
>
>
>