Re: DB2 Question

[Franco Biaggi <fbiaggi@xxxxxxxxxx>]

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.
>