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 <password>" 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