To Quiz or not to Quiz...

brian_matthewsbrian matthews brian_matthews_bmw at hotmail.com
Thu Jun 9 16:42:53 CDT 2005


of course you can write records > 255/263 chars with quiz ( why is this 
still not clear - it comes up every month ), but you use subfile statements 
in addition to report statements as below,

set subf name whatever keep
rep summ itme1 item2 ... itemn ( or rep summ all - to include all items in 
the subfile including defines)

this will write the items to a record up to 32K in length, where whatever 
can be either the name of a logical, a single file name ( written to the 
locl directory ) or can include a directory spec such as below

set subf name disk:[dirpath]whatever keep

if you exclude the keep syntax quiz will write a flat file, but there will 
be no mini dictionary to reference individual fields when readiing the 
subfile in either qtp, quiz or quick.


regards Bri,




>From: Guy Werry <guy.werry at hbms.ca>
>To: powerh-l at lists.sowder.com
>Subject: RE: To Quiz or not to Quiz...
>Date: Thu, 9 Jun 2005 16:30:24 -0500
>
>No, I don't believe that you can get Quiz to go beyond 256 / 263.
>
>Why do you need the numbers formatted?
>
>One potential area to examine is using Qtp to write to a portable subfile.
>I haven't done this for more than a decade, but if memory serves me
>correctly, the data format on a portable subfile is some sort of display
>format.  That probably won't give you commas between your thousands, but it
>may give you enough to work with.  I.E., you may get "995323.17" - I don't
>think you'll get "995,323.17".
>
>Guy L. Werry
>Senior Systems Analyst
>Hudson Bay Mining & Smelting Co., Limited.
>
>-----Original Message-----
>From: Tremblay.Pierre-McLeod at hydro.qc.ca
>[mailto: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.

_________________________________________________________________
Use MSN Messenger to send music and pics to your friends 
http://messenger.msn.co.uk



More information about the powerh-l mailing list