Re: DB2 Question

[Bruce Jin <brucej@xxxxxxxxxxxxxxxxxxxx>]

Keep in mind that deleted records also have RRN unless RGZPFM is run.

select * from TABLEX where RRN(TABLEX) between 10 and 20
may return nothing while DSPPFM show more than 20 records.

Regards.


Richard Casey wrote:
> Try this.
>
> SELECT * FROM DB2ADMIN.ST_ITEM
> WHERE RRN(ST_ITEM) BETWEEN 50 AND 75
>
> This uses the actual physical record # to perform the selection.
>
> Keep in mind that the contents of a given physical record # could change. If
> a record is deleted and the file is set to reuse deleted records -
> REUSEDLT(*YES) - then a new record could be added to that original physical
> record #.
>
> Good luck!
>
> Richard
>
>
>
> -----Original Message-----
> From: java400-l-bounces@xxxxxxxxxxxx
> [mailto:java400-l-bounces@xxxxxxxxxxxx]On Behalf Of Muhammad Owais
> Sent: Thursday, May 04, 2006 4:27 AM
> To: java101@xxxxxxxxxxxx; java400-l@xxxxxxxxxxxx
> Subject: DB2 Question
>
>
> Hello;
>
>
>   Can anybody help me in writing a simple query to get data ranging from
> record # 50 to record # 75 in the query below:
>
>          SELECT * FROM DB2ADMIN.ST_ITEM
>
>   Thanking you in an advance
>
>
>   With Regards
>
>   Muhammad Owais Bilal Awan
>
>
>
>
>
> With regards
>
> Allah Hafiz
>
>
>
> Muhammad Owais Bilal Awan,
> +923002171163
>
>
>
>
>
>
>
>
> ---------------------------------
> Yahoo! Messenger with Voice. PC-to-Phone calls for ridiculously low rates.
> --
> This is the Java Programming on and around the iSeries / AS400 (JAVA400-L)
> mailing list
> To post a message email: JAVA400-L@xxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/mailman/listinfo/java400-l
> or email: JAVA400-L-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/java400-l.
>
>
>
>