RE: Limits results of an SQL query -- RPG400-L

Subject: RE: Limits results of an SQL query
From: "Rolf Mittag" <mailing-lists@xxxxxxxxxxxx>
Date: Tue, 4 Dec 2001 16:36:24 +0100
Importance: Normal
List-Archive: <http://archive.midrange.com/rpg400-l/>
List-Help: <mailto:rpg400-l-request@midrange.com?subject=help>
List-Id: RPG programming on the AS400 / iSeries <rpg400-l.midrange.com>
List-Post: <mailto:rpg400-l@midrange.com>
List-Subscribe: <http://lists.midrange.com/cgi-bin/listinfo/rpg400-l>,<mailto:rpg400-l-request@midrange.com?subject=subscribe>
List-Unsubscribe: <http://lists.midrange.com/cgi-bin/listinfo/rpg400-l>,<mailto:rpg400-l-request@midrange.com?subject=unsubscribe>

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

Follow-Ups:

Re: Limits results of an SQL query , Christopher A. Libby

This mailing list archive is Copyright 1997-2026 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.