RE: CPYTOSTMF

["Evan Harris" <spanner@xxxxxxxxxx>]

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