To Quiz or not to Quiz...

Fri Jun 10 10:29:59 CDT 2005

Well, 

Thank you all for your answers.

There is no miracle solution for this problem, as I see now. Using the set
subfile in quiz brings back the format problem... I was hoping to avoid
typing back the decimal format because I have to do this for a number of
files.

Well nothing is perfect in this world... (except my mother of course...)

C'est la vie...

Putting the record pieces back together afterward is something I will surely
look at. VAX DCL is very powerful and fun to play with. A couple of code
lines will probably do the job. 

Again thank you all. This list is very interesting and helpful.

McLeod

-----Message d'origine-----
De : David Williams [mailto:David_Williams at westbury-homes.co.uk]
Envoyé : 10 juin 2005 05:15
À : Tremblay.Pierre-McLeod at hydro.qc.ca; powerh-l at lists.sowder.com
Objet : RE: To Quiz or not to Quiz...

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.sowder.co
m] 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/adbbe861/attachment.htm