To Quiz or not to Quiz...

[David Williams]

Pierre

 

I've done quite a bit of this type of file output, mainly for sending
attachment data to other businesses, or producing files to use in Pivot
table queries on our Intranet.

 

I've used quiz, qtp, and qdesign.

 

Started with quiz, which is easiest, and then run into the record size
problem later.

 

Used qtp and had your format problems (using subfiles from quiz does not
solve this). Hard work.

 

Then used qdesign to "echo" the files out, using run command on a large
character define made up of the necessary files.. This works fine, but
is harder work than quiz.

(I'm talking about a UNIX (HP-UX) environment - VAX must have
equivalent).

 

Then realised quiz splits the records gracefully (does not break
fields), and even if it did not, one could control the records with skip
statements.

 

So I now use quiz. If the file does not exceed the record size, that's
it.

If it does, I just put  the record halves back together with a UNIX
script after the quiz. This needs only a few lines in UNIX, and again I
assume VAX can do it easily. (In UNIX if the split is into 2 records,
just read, save, read again, then echo both together to desired file
till EOF).

 

The other advantage of quiz is it's easier to have field name headings,
with initial heading.

 

 

 

Regards 

 

David Williams

 

 

  _____  

From:
powerh-l-bounces+david_williams=westbury-homes.co.uk at lists.sowder.com
[mailto:powerh-l-bounces+david_williams=westbury-homes.co.uk at lists.sowde
r.com] On Behalf Of Tremblay.Pierre-McLeod at hydro.qc.ca
Sent: 09 June 2005 22:14
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... 



**********************************************************************
The above information is confidential to the Addresse and may be privileged. Unauthorised access and use is prohibited.

Internet communications are not secure and therefore this Company does not accept legal responsibility for the contents of this message.

If you are not the intended recipient, any disclosure, copying, distribution or any action taken or omitted to be taken in reliance on it, is prohibited and may be unlawful.
**********************************************************************

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.sowder.com/pipermail/powerh-l/attachments/20050610/6ea616a1/attachment-0001.html