MIDRANGE dot COM Mailing List Archive



Home » JAVA400-L » May 2006

Re: DB2 Question



fixed

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







Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2014 by MIDRANGE dot 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 here. If you have questions about this, please contact