To Quiz or not to Quiz...

[brian_matthewsbrian matthews]

you can use the skip syntax to write multiple lines per input record e.g.

report &
item_1 item_2 ... item_n_to_255th_column skip &
item_...  skip &
item_... skip &
item_w ... item_w+x_to_255th_column skip n

regards Bri,




>From: Jeff Hoffman <wonicon at optushome.com.au>
>To: powerh-l at lists.sowder.com
>Subject: Re: To Quiz or not to Quiz...
>Date: Fri, 10 Jun 2005 08:23:47 +1000
>
>Hi
>
>Depending upon what you are using the data for I remember some time ago 
>somebody mentioning the use of a continuation character then you can use 
>more than 1 line.
>
>Alternatively
>
>you can define a large field and then pack the data into this field and use 
>subfiles. Numeric data can be formatted using 'formatnumber'.
>
>def sep-char char*1=","  ; or tab
>def x char*2000 = trunc(xyz) + sep-char + formatnumber(abc,"$00,000.00") + 
>sep-char ...etc
>set subfile name file1
>rep sum x
>go
>
>Then in the O/S  remove trailing spaces, if necessary.
>
>Jeff Hoffman
>Wonicon Ply Ltd
>
>
>At 07:13 AM 10/06/2005, you wrote:
>
>>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.
>
>--
>= = = = = = = = = = = = = = = = = = = = = = = = = = = =
>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