Quiz (VMS) Reporting long lines (for Excel etc)

[Walker, Chris]

You can use Quiz to generate the source for this kind of extract from the
dictionary metadata - another benefit of the PHD (aka POW) dictionary
format.  But I don't see why you should have to.

Chris Walker
Tate & Lyle
London

> -----Original Message-----
> From:	Kogan, Arthur [SMTP:akogan@westpac.com.au]
> Sent:	Tuesday, April 20, 1999 2:13 AM
> To:	Chris Sharman; powerh-l@lists.swau.edu
> Subject:	RE: Quiz (VMS) Reporting long lines (for Excel etc)
> 
> I would like to add my 5 cents to the discussion.
> 
> We currently have some consultants (yes them guys) looking at our data to
> create a data map. As part of the exercise they want to extract some
> sample data, i.e. about a 1000 records from each RMS file. 
> 
> Now, we have 200 odd files with some containing over 50 fields each (some
> with rather long names). As they want to dump the data into Excel, we need
> to go through an EXTREMELY tedious process of coding quiz reports with
> 
> rep summ <field1> "," <field2> "," ...
> 
> 
> I did something similar in my UNIX days. There I just wrote a script which
> generated QSHOW file and then used the QSHOW definitions to write out QUIZ
> source. I am sure you can do something similar in DCL, but alas my
> expertise in DCL is nowhere near that of UNIX.
> 
> 
> It would be very nice to just be able to say
> 
> rep summ all
> set subfile name <name> CSV keep
> 
> 
> Regards,
> 
> Arthur Kogan
> Westpac Financial Services
> Sydney, Australia
> 
> 	-----Original Message-----
> 	From:	Chris Sharman [SMTP:Chris.Sharman@ccagroup.co.uk]
> 	Sent:	Friday, 16 April 1999 1:01 AM
> 	To:	powerh-l@lists.swau.edu
> 	Cc:	Chris.Sharman@ccagroup.co.uk
> 	Subject:	Quiz (VMS) Reporting long lines (for Excel etc)
> 
> 	I know this is an old chestnut, and I know there are various
> workarounds.
> 
> 	I'd like to suggest it as an enhancement request though: more and
> more reports
> 	are being requested for Excel, and the limit of 255 characters is a
> serious
> 	pain. Unless anyone has a patch for Quiz, or knows an Excel line
> continuation
> 	character ? Subfiles are all very well, but they don't have headings
> in.
> 
> 	Chris
> 	
> ______________________________________________________________________
> 	Chris Sharman			Chris.Sharman@CCAgroup.co.uk
> 	CCA Stationery Ltd, Eastway, Fulwood, Preston, Lancashire, PR2 9WS.
> 	= = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = =
> = = = =
> 	Subscribe: "subscribe powerh-l" in message body to
> majordomo@lists.swau.edu
> 	Unsubscribe: "unsubscribe powerh-l" in message to
> majordomo@lists.swau.edu
> 	powerh-l@lists.swau.edu is gatewayed one-way to
> bit.listserv.powerh-l
> 	This list is closed, thus to post to the list, you must be a
> subscriber.
= = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = =
Subscribe: "subscribe powerh-l" in message body to majordomo@lists.swau.edu
Unsubscribe: "unsubscribe powerh-l" in message to majordomo@lists.swau.edu
powerh-l@lists.swau.edu is gatewayed one-way to bit.listserv.powerh-l
This list is closed, thus to post to the list, you must be a subscriber.