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

[Kogan, Arthur]

This message is in MIME format. Since your mail reader does not understand
this format, some or all of this message may not be legible.

------_=_NextPart_000_01BE8ACA.FFCFB2C2
Content-Type: text/plain

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.

------_=_NextPart_000_01BE8ACA.FFCFB2C2
Content-Type: application/ms-tnef
Content-Transfer-Encoding: base64

eJ8+Ih8BAQaQCAAEAAAAAAABAAEAAQeQBgAIAAAA5AQAAAAAAADoAAEIgAcAGAAAAElQTS5NaWNy
b3NvZnQgTWFpbC5Ob3RlADEIAQSAAQA0AAAAUkU6IFF1aXogKFZNUykgUmVwb3J0aW5nIGxvbmcg
bGluZXMgKGZvciBFeGNlbCBldGMpAAsRAQmAAQAhAAAAREE2RDMxOEFBRUY2RDIxMTg4NUYwMDAw
ODM2ODM1NjcADwcBIIADAA4AAADPBwQAFAALAA0AHQACACUBAQWAAwAOAAAAzwcEABQACwAMAB8A
AgAmAQENgAQAAgAAAAIAAgABA5AGAKwLAAArAAAACwACAAEAAAADAC4AAAAAAEAAOQCwp1Ddyoq+
AR4AcAABAAAAMAAAAFF1aXogKFZNUykgUmVwb3J0aW5nIGxvbmcgbGluZXMgKGZvciBFeGNlbCBl
dGMpAAIBcQABAAAAGwAAAAG+h1F2HZ3+YF/zNBHSniEAAPa4+hEA3dDvAAACAQkQAQAAAJ0GAACZ
BgAAxgoAAExaRnUS8n0uAwAKAHJjcGcxMjXSMgD7MzYB6CACpAPjCQIAY2gKwHNldDAeIAcTAoMA
UBBWcHJx3jIRWQ5QA9URZX0KgAjI7CA7CW8OMDUVfwpgAoDZCoF1YwBQCwNjAEELYCJuDhAwMzML
piBJBCB3CGBsZCBsaQBrZSB0byBhZIEagG15IDUgYwnwpnQEIBrxdGga0GQEANRjdQQQaQIgLgqi
CoRtCoBXGtAcsHIW4AIwbOsbcBDgdhrQcwNwHgECIM5zGmABkBvSKHkHkRxBgG0gZ3V5cykakOhv
b2sLgGcbEAVACGHbHHAhoGEa4gUAZSGgGtDnIkAiEwDAcC4RUAQgCrGlIbFmHDNleASQYwQAdxrR
HFAbcHcf0RriJLB0jnIA0AVAHxNzYW0LUIMcYSIhLCBpLmUjoL8BoAhgBUAiQBlQKJAgFuC9BaFk
BCADUiSgANBoB/AdBeFmAxAn0R06Tm93/SeQdxrQHsMB0BFABHAagP8qMgQgA/AcQB8HAZALgCFi
tm8e4AXANRFAKjBlGnD7BCApoygfEy0DJkAcQQXA2wkAIXFuJvAHkCkjoyVLfGR1JwAcNCIiC4Aa
8UXqeBuwbCuDbgngGoAa8WZnHCIDYHVnKdADkUUAWFRSRU1FTFn/GuAJgBzwHMAj4ANgG7AEEQ8k
QQWgHIAhcXF1aXr9KMFwCREs5B06OEEfADKQBSCgPC7TMT4gIizqIjpFMjrELjvwHTodNH8aIByA
GoAfEhxAIWIAkG0PAxAKwQuAG1JVTklYdyIBIOAjoFQwcRrQGiBquxzABUB3A2Ai0wT1dz3wPSnB
ZwnwBJAiwRqAUVP4SE9XKiM1cTSBHFADoL8cwDRyHFFClAEBLfF0HPEfG/NAoC0QGtAoIlFVSf5a
HwEIcBuwI6AaICbwOfHdQAF5CGAboAORZBsAPa/RPrJEQ0wnkGIoMgtg9wQgG2EksHAEkEUgJRFJ
lPsnoAQgbitgP+M0UArBHEB/IaIkUD8iPB89IUCBGlNi/xrQLmEbcAMAG7Aa4kBTT2HvAaAnIRrx
JuB5OQ86EgdA7wlQHUMRETnxYkLzMQI6QMMxAjrAQ1NWIBrAOFAhTb8KUmVnCxFzLM8dOgcQHEAh
4UtvVrALkMcdpUBwCrBjIEYLgABw9yTwB0AGUnZP8RCgHUMGsOpkNFB5J5BBQGEmQBqg/mFVfgsw
GqAPMRjBAUA20Yci0CZgEeQxNiAtXsJaTwUQZ1mBAyBNNxFhf0HwXsMdNl3UXaELE13WaTAtMTQ0
AUAaoDE4tyiQDMFiY2JZYANhOgyD2mIRQEM1EEvhUxDhA4JAW1NNVFA6ZIMu+WTlQGNIAAnACGAj
kAWg8C51a10dNWOQBmACML9j92OwPXA/gCeQXpFBEqAZAxExOWoQKHA6MDHlEVBNZ5dUb2P3OGAr
oOByaC1sQBqgQHA/oDkD4GF1J8AygGeXQ2PfY/xmH2ckZ5hTwGpeAWP38lE4AihWBeAhAFaQOGL/
IWIwsxqgNFAgAQIQBcAzs/EkoHRjKWBvYXpdJAzQvwHBGMETkROSDAE89WtMEf8cMUvhS+EDkQbw
GoAQ0FkB/m4oMCeQQ0J4lz/yCsBPcecKwDaDGkByawrACGBDUNs/oDyLJxqIH5BnQfBAcf8tEBsQ
eWMJ8BDgWbAgkBvB3yjBN/B+4hxANTI6G1AFsP9DJIFzOEUdNHuiT2AhYoB1/zRxdBd6dBxCGqA+
YCQjFpH/eeEKwCZRBJB5NB8ABnE2kc8dNAqwC4AjoFVuLMF5Yv9HwDRQHrGHIgqwdMAp0HQS/3IC
J5AFsXiyeWN0VHOiLZM9C4B1IaAc8R00hmcgP/9w8iyke6JS4U+EK6BS8En08yVDSEBuJwVAHsMc
UBsg3yFheTEdHGSDHTRfk1+Ub/uVf5aPX5JJZNYMhJkEbq34Q0NBb8+akQYAAZBFIlFPokx0ZCeQ
RUpwdHslkFtBRhpgGkAEcCeQUO8W4EBwAiAnkExZoUpwPfCLFuCeEVIS0DlXUx0l/D0goG+hf6KP
o5+kA1qV71PABPJPYIFQIlOxpaRr9/87AD7CX7RKAARwG3Aa8QDA9mopAQNwb2yPHVKIkKY3/6YB
fNCmP6dMqH9s3mwPbRS/S9JWsCLQnVE0cYkxLZ1RtRriYi0QLq5DWiEur4bfHTQ/0EvhrkJL0mMJ
AEPh/yeQV/Eb8zhggMIcJK5CJ5DdR8JtUHZToqWkch0lFJECALlQAAAAAwD9P1IDAAAeAEIQAQAA
ACUAAAA8MDA5RDZBRTEuOEZEQTkzMkMuNEBjY2Fncm91cC5jby51az4AAAAACwAAgAggBgAAAAAA
wAAAAAAAAEYAAAAAA4UAAAAAAAADAAeACCAGAAAAAADAAAAAAAAARgAAAAAQhQAAAAAAAAMAI4AI
IAYAAAAAAMAAAAAAAABGAAAAAFKFAAB0EAAAHgAkgAggBgAAAAAAwAAAAAAAAEYAAAAAVIUAAAEA
AAAFAAAAOC4wMgAAAAADAA+ACCAGAAAAAADAAAAAAAAARgAAAAABhQAAAAAAAAsAKYAIIAYAAAAA
AMAAAAAAAABGAAAAAA6FAAAAAAAAAwAMgAggBgAAAAAAwAAAAAAAAEYAAAAAEYUAAAAAAAADACuA
CCAGAAAAAADAAAAAAAAARgAAAAAYhQAAAAAAAB4AOoAIIAYAAAAAAMAAAAAAAABGAAAAADaFAAAB
AAAAAQAAAAAAAAAeADuACCAGAAAAAADAAAAAAAAARgAAAAA3hQAAAQAAAAEAAAAAAAAAHgA8gAgg
BgAAAAAAwAAAAAAAAEYAAAAAOIUAAAEAAAABAAAAAAAAAAMAJgAAAAAAAwA2AAAAAAAeADFAAQAA
AA8AAABLT0dBTkE0RENCNzgzOAAAAwAaQAAAAAAeADBAAQAAAA8AAABLT0dBTkE0RENCNzgzOAAA
AwAZQAAAAAADAIAQ/////wIB+T8BAAAAYgAAAAAAAADcp0DIwEIQGrS5CAArL+GCAQAAAAYAAAAv
Tz1XRVNUUEFDL09VPVdCQy9DTj1SRUNJUElFTlRTL0NOPU1TTUFJTCBBRERSRVNTRVMvQ049S09H
QU5BNERDQjc4MzgAAAAeAPg/AQAAAA4AAABLb2dhbiwgQXJ0aHVyAAAAHgA4QAEAAAAPAAAAS09H
QU5BNERDQjc4MzgAAAIB+z8BAAAAYgAAAAAAAADcp0DIwEIQGrS5CAArL+GCAQAAAAYAAAAvTz1X
RVNUUEFDL09VPVdCQy9DTj1SRUNJUElFTlRTL0NOPU1TTUFJTCBBRERSRVNTRVMvQ049S09HQU5B
NERDQjc4MzgAAAAeAPo/AQAAAA4AAABLb2dhbiwgQXJ0aHVyAAAAHgA5QAEAAAAPAAAAS09HQU5B
NERDQjc4MzgAAEAABzBwjYq5yIq+AUAACDDCss//yoq+AR4APQABAAAABQAAAFJFOiAAAAAAHgAd
DgEAAAAwAAAAUXVpeiAoVk1TKSBSZXBvcnRpbmcgbG9uZyBsaW5lcyAoZm9yIEV4Y2VsIGV0YykA
CwApAAAAAAALACMAAAAAAAMABhBk9vZoAwAHEGQGAAADABAQAAAAAAMAERABAAAAHgAIEAEAAABl
AAAASVdPVUxETElLRVRPQURETVk1Q0VOVFNUT1RIRURJU0NVU1NJT05XRUNVUlJFTlRMWUhBVkVT
T01FQ09OU1VMVEFOVFMoWUVTVEhFTUdVWVMpTE9PS0lOR0FUT1VSREFUQVRPQwAAAAC/PA==

------_=_NextPart_000_01BE8ACA.FFCFB2C2--
= = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = =
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.