I don't know. But you don't need to use the i5_ database functions. You
can use the db2_ functions. Check out the db2_ database functions at:
http://www.php.net/manual/en/ref.ibm-db2.php
I'm assuming that pagination with LIMIT would work with the db2_
database functions. I haven't tried it, though.
I prefer using the db2_ functions because you get more functionality
than provided in the PHP Toolkit. I especially like using
db2_fetch_assoc because you get an associative array where the key is
the name of the field in the DB2 file. It makes code that processes
results much easier to read. I grew up on COBOL and like
self-documenting code.
I do use i5_ functions for other stuff. I don't want to imply something
is wrong with the PHP Toolkit.
Kelly
-----Original Message-----
From: web400-bounces@xxxxxxxxxxxx [mailto:web400-bounces@xxxxxxxxxxxx]
On Behalf Of Larry Kleinman
Sent: Thursday, December 03, 2009 2:05 PM
To: Web Enabling the AS400 / iSeries
Subject: Re: [WEB400] php vs net.data
Pretty cool, Kelly. The only question is will it work with ZendCore
using
i5_query instead of mysql_query?
Larry Kleinman
Kleinman Associates, Inc.
212-949-6469
203-255-4100
"Kelly Cookson" <KCookson@xxxxxxxxxxxx>
Sent by: web400-bounces@xxxxxxxxxxxx
12/03/2009 02:50 PM
Please respond to
Web Enabling the AS400 / iSeries <web400@xxxxxxxxxxxx>
To
"Web Enabling the AS400 / iSeries" <web400@xxxxxxxxxxxx>
cc
Subject
Re: [WEB400] php vs net.data
Here's a page that may be along the lines of what you seek:
http://www.phpsimplicity.com/tips.php?id=1
Kelly
-----Original Message-----
From: web400-bounces@xxxxxxxxxxxx [mailto:web400-bounces@xxxxxxxxxxxx]
On Behalf Of Larry Kleinman
Sent: Thursday, December 03, 2009 1:03 PM
To: Web Enabling the AS400 / iSeries
Subject: [WEB400] php vs net.data
Does anyone know if there is a PHP equivalent for the Net.Data report
variables called RPT_MAX_ROWS (which limits the number of report rows
returned by a SQL call) and START_ROW_NUM (which determines the starting
row of a SQL result set to show)
Larry Kleinman
Kleinman Associates, Inc.
212-949-6469
203-255-4100
midrange.com
