Hi Steve

In addition to the other suggestions you can get there by creating one large result field in the query something like:

'"'||field1||'", "'||field2||'",'||numfield||'

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.

Regards
Evan Harris

-----Original Message-----
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
Subject: CPYTOSTMF

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?

Regards

Steve Dodkins
I.T Manager

ebm-papst UK Ltd
Chelmsford Business Park,
CM2 5EZ Chelmsford,
UK
Tel: +44 (0) 1245 468555
Dir: +44 (0) 1245 456510
steve.dodkins@xxxxxxxxxxxxxxx
www.ebmpapst.co.uk



This thread ...

Replies:

Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2019 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 [javascript protected email address].