QUIZ Reports Zero Records Read

[Brent Gillan]

Brian, I had run into this problem a few years back.  The only way we could
guarantee that we were getting correct results was to NOT compile the program.
We just "used" the quiz source code, with the last 2 lines as GO and EXIT.
That was on HP-UX 10.0,  PHV7.33c5 (I think that was the version), and Oracle
V7.3.

I thought it might have had something to do with the number of records in the
temp subfile, at the time you compiled the quiz report. There was no time for
speculation, or invalid results (the application was required sooner than ASAP
- as always), so the "source code" route was taken.

Brian Schalme wrote:

> We have noticed on four occasions that a compiled QUIZ
> program will not produce a report. Yet when we re-compile
> the program and use the very same data, it works. We
> have been unable to reproduce the problem and are
> wondering if this is a known problem.
>
> Environment: PH8.19C5, MPE/iX 5.5 Express Patch 4,
> HP3000/918, IMAGE.
>
> Now I know what you're thinking: :FILE equates and/or
> temporary/permanent file conflicts. This is the first thing we checked.
> There are no :FILE equates pointing elsewhere for the files being
> referenced, and the only version of the subfile is the temporary file.
>
> We have a QTP program that produces a subfile. This
> subfile is then used by a QUIZ program to link to a
> Manual Master, add up some totals, then produce a report.
> There is no SELECT statement in this QUIZ program.
>
> We run the QTP program and it completes successfully. It
> produces a temporary subfile with several thousand
> records in it. We then run the QUIZ program, but it
> reports zero records read, and terminates normally. Of
> note is that the QUIZ program comes back instantly to
> tell us zero records read, as if it really didn't look.
> Yet we can write an ad-hoc QUIZ program to access the
> same subfile during the same session and link to the
> same Manual Master, and we get data.
>
> If we recompile the program, but answer "N" to the
> question of whether we want to replace the compiled
> program that is already there, and do a "GO", we get
> the report we expect.
>
> Here's the best part: We can recompile the QUIZ program
> using the same source code file, run it, and it produces
> a 20-some page report. It works fine.
>
> There has been no structural change to the Manual Master.
> The two of us here are the only ones working with it.
>
> We tried to duplicate the conditions as accurately as
> possible. We used the same compile job that created the
> two problem programs. We then ran the QTP program, and
> then the QUIZ program - it produced the report we were
> expecting. We checked for conflicts between temporary
> and permanent subfiles - none. We check for :FILE equates
> pointing elsewhere - none.
>
> I have noticed this with three other QUIZ programs. I
> was even able to replicate the problem once using ad-hoc
> QTP and QUIZ programs using PH8.19C4 in August. Same
> procedure: write a QTP program to make a subfile, then
> write a QUIZ program to read it. The first time I ran
> the QUIZ program it reported zero records read. I write
> the program again (access *xxx, rep all, go), and run
> it, I get data.
>
> If this only happened once, I could write it off as a fluke (cosmic
> dust, increased solar activity, etc.). But four times on different
> occasions? I'm wondering...
>
> Any clues?
>
>         Brian Schalme
>         Airspeed Consulting
>         bschalme@mbnet.mb.ca
> = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = =
> Subscribe: "subscribe powerh-l" in message body to majordomo@lists.swau.edu
> Unsubscribe: "unsubscribe powerh-l" in message to majordomo@lists.swau.edu
> This list is closed, thus to post to the list, you must be a subscriber.

--
Brent Gillan
Aerocomp Solutions Inc.
mailto:bgillan@aerocomp.ca


= = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = =
Subscribe: "subscribe powerh-l" in message body to majordomo@lists.swau.edu
Unsubscribe: "unsubscribe powerh-l" in message to majordomo@lists.swau.edu
This list is closed, thus to post to the list, you must be a subscriber.