Hello,
I do not have the code but you should use a CachedRowSet,
this is supported by JT/400.
Paul Nicolay wrote:
> Hi,
>
> The problem is that DB2 doesn't support this, but it can be done by a trick
> which works by combining the following statements as one
>
> - Select the TOP 75 in descending order with cirteria
> - Select the TOP 25 of these in ascending order
>
> Kind regards,
> Paul
>
>
> ----- Oorspronkelijk bericht -----
> Van: Muhammad Owais [mailto:muhammadowaisbilal@xxxxxxxxx]
> Verzonden: donderdag, mei 4, 2006 10:26 AM
> Aan: java101@xxxxxxxxxxxx, java400-l@xxxxxxxxxxxx
> Onderwerp: 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.
>
