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
ï please don't print this e-mail unless you really need to.
-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx [mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Tom
Sent: 08 October 2009 21:23
To: 'Midrange Systems Technical Discussion'
Subject: RE: SQL and a Running/Moving Total
+1 funny
Tom H
-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx
[mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of iseries@xxxxxxxxxxxx
Sent: Thursday, October 08, 2009 3:06 PM
To: 'Midrange Systems Technical Discussion'
Subject: RE: SQL and a Running/Moving Total
Table has 3 columns,Name,year,count and I need a total of the "count"
field
for each name over a 3 yr period, if there are NOT 3 years available
then no
output row.
Project approved. Please proceed.
<snip>
--
"When a man says he approves of something in principle, it means he hasn't
the slightest intention of putting it into practice."
As an Amazon Associate we earn from qualifying purchases.