Consider building a view that does the things that your 'extract' program does. Or if a View has to process too many records, maybe a User Defined Table Function would do the trick. If you have special routines that process data rather than jus going and getting it from the database, you can convert those to user defined functions and include those calculations in the view that way. We had a Bill of Materials program which was extremely convoluted until I turned it into a User Defined Table function with joins and calls out to UDF's to get other bits of data from the database. Now I can use that one UDTF wherever I need to display the BOM. Works great from 5250 and web apps.
Mark Murphy
STAR BASE Consulting, Inc.
mmurphy@xxxxxxxxxxxxxxx
-----"Roche, Bob" <broche@xxxxxxxxxxxxxxxxx> wrote: -----
To: "Web Enabling the IBM i (AS/400 and iSeries)" <web400@xxxxxxxxxxxx>
From: "Roche, Bob" <broche@xxxxxxxxxxxxxxxxx>
Date: 11/02/2016 07:27PM
Subject: Re: [WEB400] PHP and RPG, work file question
We don't currently have anything setup to run 27 x 132. We are moving all new development to PHP. So this was supposed a simple display screen to start on. I just liked the idea of reusing the RPG code, until I thought of the stateless issue. I'm starting to rewrite this program.
-----Original Message-----
From: WEB400 [mailto:web400-bounces@xxxxxxxxxxxx] On Behalf Of Don Brown
Sent: Wednesday, November 02, 2016 4:45 PM
To: Web Enabling the IBM i (AS/400 and iSeries) <web400@xxxxxxxxxxxx>
Subject: Re: [WEB400] PHP and RPG, work file question
If screen size of 24 x 80 is not big enough why not just change the display size to 27 x 132 as an interim fix anyway.
If the application is running primarily in green screen environment taking one screen out to the browser using PHP seems a little disjointed but I have no idea of the complete application.
My 2 cents
Don Brown
From: Luis Rodriguez <luisro58@xxxxxxxxx>
To: "Web Enabling the IBM i (AS/400 and iSeries)"
<web400@xxxxxxxxxxxx>
Date: 03/11/2016 01:49 AM
Subject: Re: [WEB400] PHP and RPG, work file question
Sent by: "WEB400" <web400-bounces@xxxxxxxxxxxx>
We have a similar situation in some of our Client/Server programs. What we do is to place the User ID as the first key field of our table. Before we write the data to the work file we delete all the records pertaining to the requesting User. The client program "knows" it must read all the records beginning with the User ID.
HTH,
Luis
On Wed, Nov 2, 2016 at 10:34 AM Roche, Bob <broche@xxxxxxxxxxxxxxxxx>
wrote:
I have an interactive inventory screen. The users would like to add a
few
more columns, but the 24 x 80 screen is full so I'm going with PHP.
The program to help build the inventor list uses a separate alone
program
to build a work file in qtemp. The display program reads it and
everything
is fine. Many people can use it at the same time since the work file
is
in
temporary storage. I would like to use this program but a call from
PHP can't rely on temporary storage for the next SQL call to get the data.
Has
anyone already solved a similar issue, or should i just rewrite the
work file program in PHP?
--
This is the Web Enabling the IBM i (AS/400 and iSeries) (WEB400)
mailing list To post a message email: WEB400@xxxxxxxxxxxx To
subscribe, unsubscribe, or change list options,
visit:
https://urldefense.proofpoint.com/v2/url?u=http-3A__lists.midrange.com
_mailman_listinfo_web400&d=DQICAg&c=S6jE3hMA0s16gx2_CUBBn4vjc1odLunI6M
Svd_AfdV8&r=Ub_YbVSedaHB7-0yGANN94iTrfkU2nCKT1D5-5Jv01Y&m=CwE7hnlYHp6A
KRAvwcosXfGNz7Dk5oSIUsZZCsGaxGU&s=A2yMIaL-9eYLXzazQL_6kolvHVFJPRCESQkA
Yvo_6ZY&e=
or email: WEB400-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives at
https://urldefense.proofpoint.com/v2/url?u=http-3A__archive.midrange.com_web400&d=DQICAg&c=S6jE3hMA0s16gx2_CUBBn4vjc1odLunI6MSvd_AfdV8&r=Ub_YbVSedaHB7-0yGANN94iTrfkU2nCKT1D5-5Jv01Y&m=CwE7hnlYHp6AKRAvwcosXfGNz7Dk5oSIUsZZCsGaxGU&s=SW9-l2hzTEXw7qEiXF6jhaA5HnM-lbkZ5F6iHctGTJs&e= .
--
Luis Rodriguez
--
This is the Web Enabling the IBM i (AS/400 and iSeries) (WEB400) mailing list To post a message email: WEB400@xxxxxxxxxxxx To subscribe, unsubscribe, or change list options,
visit:
https://urldefense.proofpoint.com/v2/url?u=http-3A__lists.midrange.com_mailman_listinfo_web400&d=DQICAg&c=S6jE3hMA0s16gx2_CUBBn4vjc1odLunI6MSvd_AfdV8&r=Ub_YbVSedaHB7-0yGANN94iTrfkU2nCKT1D5-5Jv01Y&m=CwE7hnlYHp6AKRAvwcosXfGNz7Dk5oSIUsZZCsGaxGU&s=A2yMIaL-9eYLXzazQL_6kolvHVFJPRCESQkAYvo_6ZY&e=
or email: WEB400-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives at
https://urldefense.proofpoint.com/v2/url?u=http-3A__archive.midrange.com_web400&d=DQICAg&c=S6jE3hMA0s16gx2_CUBBn4vjc1odLunI6MSvd_AfdV8&r=Ub_YbVSedaHB7-0yGANN94iTrfkU2nCKT1D5-5Jv01Y&m=CwE7hnlYHp6AKRAvwcosXfGNz7Dk5oSIUsZZCsGaxGU&s=SW9-l2hzTEXw7qEiXF6jhaA5HnM-lbkZ5F6iHctGTJs&e= .
--
This is the Web Enabling the IBM i (AS/400 and iSeries) (WEB400) mailing list To post a message email: WEB400@xxxxxxxxxxxx To subscribe, unsubscribe, or change list options,
visit:
https://urldefense.proofpoint.com/v2/url?u=http-3A__lists.midrange.com_mailman_listinfo_web400&d=DQICAg&c=S6jE3hMA0s16gx2_CUBBn4vjc1odLunI6MSvd_AfdV8&r=Ub_YbVSedaHB7-0yGANN94iTrfkU2nCKT1D5-5Jv01Y&m=CwE7hnlYHp6AKRAvwcosXfGNz7Dk5oSIUsZZCsGaxGU&s=A2yMIaL-9eYLXzazQL_6kolvHVFJPRCESQkAYvo_6ZY&e=
or email: WEB400-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives at
https://urldefense.proofpoint.com/v2/url?u=http-3A__archive.midrange.com_web400&d=DQICAg&c=S6jE3hMA0s16gx2_CUBBn4vjc1odLunI6MSvd_AfdV8&r=Ub_YbVSedaHB7-0yGANN94iTrfkU2nCKT1D5-5Jv01Y&m=CwE7hnlYHp6AKRAvwcosXfGNz7Dk5oSIUsZZCsGaxGU&s=SW9-l2hzTEXw7qEiXF6jhaA5HnM-lbkZ5F6iHctGTJs&e= .
midrange.com
