Re: Pagination with PHP and DB2 (simple working example)

[Jon Paris <jon.paris@xxxxxxxxxxxxxx>]

Just to save anyone else wasting time ...

Kelly has indeed provided a very useful example ... but I should point  
out that it appears to require the V5R4 and later OLAP additions to  
DB2 for i. I cannot access my V5R4 system today and so was testing on  
a V5R3 box. Doesn't work!  Trolling the archives revealed that the  
problem is that ROWNUMBER() OVER() apparently wasn't part of the base  
product until V5R4.


Jon Paris

www.Partner400.com
www.SystemiDeveloper.com



On 4-Dec-09, at 4:44 AM, web400-request@xxxxxxxxxxxx wrote:

> This is certainly not the only way to paginate with DB2. I just  
> thought
> it might be useful to have a working example in the WEB400 archive.
>
>
> The script assumes a DB2 file called MYLIB/MYEOP. The MYEOP file
> contains four fields:  EOPYEAR, EOPPRD, EOPBEGDT, EOPCLSDT.