Re: PHP and RPG, work file question

[Luis Rodriguez <luisro58@xxxxxxxxx>]

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: http://lists.midrange.com/mailman/listinfo/web400
> or email: WEB400-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/web400.
>
> --

Luis Rodriguez