PCONNECT is a persistent connection. It's available in both the I5_ and
DB2_ flavors.
You can definitely pass everything at once if you want. Or if you prefer,
you can repeatedly call a procedure and receive one record at a time. It's
all in how you build it. You can break it up however you want.
Personally, I prefer my procedures to return one "item" at a time. Let's
say I'm building an Order Edit application. I would have a procedure to
return all of the Order Header information in one go. I would also have a
procedure to return the data for an Order Detail line. I would call the
Detail procedure for however many lines I want to display on the webpage.
This way, if I decide I want more or less Detail lines on the page, I only
need to change the "View" layer, the PHP script. That way, I don't make
changes to the service program that may break other applications, web or
5250, that may be using the same service program. But that is all
preference.
Yes, I pass the first or last record on my screen back to my procedures
for positioning purposes. No need to build up data that you are not going
to use.
Brian May
Project Lead
Management Information Systems
Garan, Incorporated
Starkville, Mississippi
Young i Professionals
http://www.youngiprofessionals.com
"Tom Deskevich" <thomas.l.deskevich@xxxxxxxxxxxxx>
Sent by: web400-bounces@xxxxxxxxxxxx
10/06/2009 06:48 AM
Please respond to
Web Enabling the AS400 / iSeries <web400@xxxxxxxxxxxx>
To
<web400@xxxxxxxxxxxx>
cc
Subject
[WEB400] Can you read a file in QTEMP on the i5 via the PHP script?
Clarification, please
First what is PCCONNECT, I was advised to use it, but never heard of it.
Second, if you use a stored procedure or service program, how do you get
the
page data to the PHP script? I started using an array passing parameters
for
everything in the screen. Is there a better way?
Third, how do you handle navigation? Do you remember where you left off
and
then set yourself there
In the file and read forwards or backwards? Or do you always do a full
load
of the subfile?
Thanks.
Tom Deskevich
Infocon Corporation
Phone 814-472-6066
Fax 814-472-5019
midrange.com
