Re: [WEB400] FW: QtmhCvtDb trouble

[Mel Rothman <mel@xxxxxxxxxxxxxx>]

Let me add my two cents.

Bob, its no problem that you typed Beckman instead of Rothman.  That puts me in 
good company!

Bob, there is only one L in Mel :-) .  No problem there, either.

My experience is that the QtmhCvtDB problem with large data structures has 
appeared and been fixed in several releases.  If one insists on using 
QtmhCvtDB, be sure to install the latest group PTFs for your release's HTTP 
server.  Also, install any PTFs not included in the latest group PTF.  This 
should solve the problem.

However, my strong recommendation is to use QzhbCgiParse or the CGIDEV2 
subprocedures based on QzhbCgiParse (the ones that start with zhb).

Another recommendation: if you want your CGI programs to perform well, use 
named activation groups.  When you do this, be careful about reinitializing 
variables that need to be initialized each time the program is called.  Also, 
if multiple CGI programs are to use the same named activation group. make sure 
they all read the same external HTML file(s).  If you do this, the file(s) will 
be read and processed only once, the first time the program runs.  On 
subsequent runs, if the list of files has not changed, and the files' 
timestamps have not changed, the subprocedures that read the HTML quickly 
return without going through the extensive work of reading the files and 
building the structures used for high performance processing by the UpdHTMLVar 
and WrtSection subprocedures.

Finally, Monday, June 24 will be my last day at IBM.

I plan to rest for a while, then start working on setting up my own consulting 
company.


Mel Rothman, CGIDEV2 Author
http://www.easy400.ibm.it/en




Bob Cozzi wrote:
>
> I've heard of this bug. The best thing to do if you want to continue to
> use CvtDb is to make sure you set on *INLR before the CGI program ends.
>
> The best thing you can do if you want it to work in the future, is to us
> QzhbCgiParse and get he fields one at a time.
> Mel Beckman's zhbGetVar (in CGIDEV2) wraps QzhbCgiParse so that normal
> humans can actually use it. It's the only thing I use nowadays. I used
> the be in love with CvtDb, but there's too many issues with it to make
> it worth the effort anymore.
>
> Bob Cozzi
>
> > -----Original Message-----
> > From: web400-admin@midrange.com
> > [mailto:web400-admin@midrange.com] On Behalf Of Phil
> > Sent: Thursday, June 20, 2002 7:52 PM
> > To: WEB400
> > Subject: [WEB400] FW: QtmhCvtDb trouble
> >
> >
> > All,
> >
> > I am having trouble with this API.  The value of stdin when
> > this api is called is correct - reflects what the user
> > entererd in.  But when the api is called, it returns data
> > from the first time the api was called.  This seems only to
> > be happening where the pf used for the external ds is long,
> > and only on the right most fields.  The left most fields
> > contain the correct data.
> >
> > This as400 is v4r4.  The file is 5,163 bytes long and has 25 fields.
> >
> > Is this a known issue?
> >
> > Thanks,
> >
> > Phil
> >
>