In addition to the other suggestions you can get there by creating one large result field in the query something like:
Once you have your single calculated field output it to a file and run your CPYTOSTMF. Being able to preview the data helps get the formatting right as a minor bonus.
You could go further and create the separators as a calculated field to make it a bit simpler
You'll need to check the concatenations and quotes as it's a while since I last did this.
It's not necessarily the way I would do it, but for a quick and dirty solution or where a program is too much trouble it's a handy approach.
From: midrange-l-bounces@xxxxxxxxxxxx [mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Steve Dodkins
Sent: Friday, 9 October 2009 8:16 p.m.
To: Midrange Systems Technical Discussion
I'd like to be able to use CPYTOSTMF to copy a file created by a query but I get an error message
'Object is not a file or is a file with attributes not
supported by this command. '
is there a way around this?
ebm-papst UK Ltd
Chelmsford Business Park,
CM2 5EZ Chelmsford,
Tel: +44 (0) 1245 468555
Dir: +44 (0) 1245 456510
This thread ...
Re: Calling SQL from QSH was: CPYTOSTMF, (continued)
This mailing list archive is Copyright 1997-2020 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact