To Quiz or not to Quiz...

[brian_matthewsbrian matthews]

one last comment,

if you decide to use qtp, you will have to use the same defined item 
approach to get the formatted numeric output so you might as well use quiz - 
which has no locking and more efficient sorting.

P.S. appologies to Guy, but I get so irritated when informed opinion 
persists with the notion that quiz cannot create records > 255/270 chars.

P.P.S the actual record length limitation of quiz subfiles is 1023 items 
with max char lengths of 2043 chars
which is effectively 2000K and not 32K as I suggested earlier.

regards Bri,




>From: "brian_matthewsbrian matthews" <brian_matthews_bmw at hotmail.com>
>To: Tremblay.Pierre-McLeod at hydro.qc.ca, powerh-l at lists.sowder.com
>Subject: RE: To Quiz or not to Quiz...
>Date: Thu, 09 Jun 2005 22:03:05 +0000
>
>ah yes, this is what I was thinking of ( excluding keep will be generate a 
>temp dict only ).
>
>Quiz will provide formatted data only to a report file without the summary 
>option.  A subfile will give you what you want but you have to put in some 
>work. Sadly, 7.10.E does not have the formatnumber option so you will have 
>to format numerics yourself using techniques like that below,
>
>for a quiz reported numeric item such as 999,999.99 you will have to code 
>as below for all numeric types using defines for each,
>
>e.g. data item nett_price and assuming a integer type with input scale two 
>and 2 decimal places,
>
>define d_nett_price char *10 = &
>ascii ( floor (nett_price /100000 ) ) + "," + &
>ascii ( mod(floor (nett_price /100 ), 1000 ) ,3 ) + "." + &
>ascii ( mod (nett_price , 100 ),2 )
>
>this is from memory only and without access to quiz, so I would be 
>astonished if there were no errors :)
>
>regards Bri,
>
>
>
>
>>From: "Al Karman" <Alk at liasophia.com>
>>To: <Tremblay.Pierre-McLeod at hydro.qc.ca>, <powerh-l at lists.sowder.com>
>>Subject: RE: To Quiz or not to Quiz...
>>Date: Thu, 9 Jun 2005 16:24:45 -0500
>>
>>Pierre,
>>
>>
>>
>>Try writing output to a subfile instead of a disc file.using the
>>NODICTIONARY option.
>>
>>
>>
>>
>>
>>Al
>>
>>
>>Al Karman
>>Director of Information Technology
>>lia sophia
>>  <mailto:alk at liasophia.com> alk at liasophia.com
>>
>>
>>   _____
>>
>>From: powerh-l-bounces+alk=liasophia.com at lists.sowder.com
>>[mailto:powerh-l-bounces+alk=liasophia.com at lists.sowder.com] On Behalf Of
>>Tremblay.Pierre-McLeod at hydro.qc.ca
>>Sent: Thursday, June 09, 2005 4:14 PM
>>To: powerh-l at lists.sowder.com
>>Subject: To Quiz or not to Quiz...
>>
>>
>>
>>Hi everybody,
>>
>>I'm trying to extract powerhouse data to an ASCII file keeping the correct
>>dictionary picture format.
>>
>>Using Quiz, everything is OK, it's like a report, so the numbers are
>>formatted according to the dictionary format without having to specify a
>>picture for every field.  Good!   But, I cannot exceed the 263 characters
>>barrier for a record.  It wraps the line. ...  hum...  too bad...
>>
>>Using QTP, I don't have the wraparound problem but the format of the 
>>fields
>>is catastrophic.  Presented as they are stored on file, without any 
>>decimal
>>format, the numbers are useless.
>>
>>There is certainly a way to create records more than 263 characters long 
>>in
>>Quiz or to use the dictionary format in QTP ?
>>
>>Surely I'm missing something.... ?
>>
>>I'm talking about powerhouse 7.10.E sitting on a vax computer running
>>OpenVMS 6.2
>>
>>Thank's !
>>
>>Best regards.
>>
>>
>>Pierre McLeod Tremblay
>>Consultant T.I. / I.T. Consultant
>>pmcleod at videotron.ca
>>819.263.0791 fax: 819.263.0792
>>My french is better than my english.  Sorry for the Frenglish...
>>
>>--
>>= = = = = = = = = = = = = = = = = = = = = = = = = = = =
>>Mailing list: powerh-l at lists.sowder.com
>>Subscribe: "subscribe" in message body to 
>>powerh-l-request at lists.sowder.com
>>Unsubscribe: "unsubscribe &lt;password&gt;" in message body to 
>>powerh-l-request at lists.sowder.com
>>http://lists.sowder.com/mailman/listinfo/powerh-l
>>This list is closed, thus to post to the list you must be a subscriber.
>
>_________________________________________________________________
>Be the first to hear what's new at MSN - sign up to our free newsletters! 
>http://www.msn.co.uk/newsletters
>
>--
>= = = = = = = = = = = = = = = = = = = = = = = = = = = =
>Mailing list: powerh-l at lists.sowder.com
>Subscribe: "subscribe" in message body to powerh-l-request at lists.sowder.com
>Unsubscribe: "unsubscribe &lt;password&gt;" in message body to 
>powerh-l-request at lists.sowder.com
>http://lists.sowder.com/mailman/listinfo/powerh-l
>This list is closed, thus to post to the list you must be a subscriber.

_________________________________________________________________
Winks & nudges are here - download MSN Messenger 7.0 today! 
http://messenger.msn.co.uk