To Quiz or not to Quiz...

[Jeff Hoffman]

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 <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.