Quiz Reporting Errors

[MattO1@aol.com]

In a message dated 2/19/99 9:55:37 AM EST, John Pickering writes:

<< Between Quiz 4.00 and Quiz 5.01, Cognos changed the assumed file for an   
 unqualified item from the last file in the access statement containing   
 the item to the first file. This caught a lot of lazy programmers (the   
 kind who never qualify anything) and resulted in report programs which no   
 longer worked.
  >>
Interesting you mention that.  You are right, some programs did stop working,
but usually QTP, not Quiz (although it is possible they gave incorrect answers
<grin>). 

The most distinctive change I remember in going to 5.01 is that most reports
ran *much* faster!  The difference seemed to be that in SELECT statements
under the 4.00  the *last* occurrence of an unqualified item in the list of
files in the ACCESS statement would be selected.  For example, if an item
appeared in the 1st and the 5th file in the ACCESS statement, then 4.00 Quiz
would have to read records from all 5 files before rejecting the record
complex.

With 5.01, Quiz selected the *first* item found.  Using the example above,
Quiz 5.01 would only read one record then immediately reject the record
complex.

I recall distinctive discovering this when a client asked me why his program
ran so slow on his terminal and so *fast* on mine! ;-)  It turned out I had my
UDC set to point at 5.01 and his was still pointing at 4.00.

No great earth-shattering information here, just an old PH coot reminiscing
;-)

Matt Ohmes
Matt.Ohmes@Cognos
MattO1@AOL.COM  (that's 'oh' 1 not "zero" 1) 
= = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = =
Subscribe: "subscribe powerh-l" in message body to majordomo@lists.swau.edu
Unsubscribe: "unsubscribe powerh-l" in message to majordomo@lists.swau.edu
powerh-l@lists.swau.edu is gatewayed one-way to bit.listserv.powerh-l
This list is closed, thus to post to the list, you must be a subscriber.