Re: CPYTOIMPF

I had to look at that a bit. Very strange. Error says TO-file but lists
the from-file. Text is confusing. Apparently, the command is really
having difficulty with the file type of the source. So why blame the
source and refer to it as the tofile (destination)?

John McKee


On Tue, Jun 24, 2014 at 12:43 PM, <rob@xxxxxxxxx> wrote:

Tried to use my old nemesis, CPYTOIMPF. Not going well.
CPYTOIMPF FROMFILE(SSC/CLUST00001) TOSTMF('/ROB/CLUSTERDEPLOYMENT.TXT')
STMFCCSID(*PCASCII) RCDDLM(*CRLF) FLDDLM(*TAB) ADDCOLNAM(*SQL)
CPF2803To-file CLUST00001 in SSC not allowed.
-- The Copy To Import File (CPYTOIMPF) command requires a source, or
externally described physical file on the TOFILE parameter.
Recovery . . . : Do one of the following to change the file name on the
-- If the CPYFRMIMPF, or CPYTOIMPF command was used, specify the correct
file type on the TOFILE parameter.

Display File Field Description
Input parameters
File . . . . . . . . . . . . . . . . . . . : CLUST00001
Library . . . . . . . . . . . . . . . . . : SSC
File Information
File . . . . . . . . . . . . . . . . . . . : CLUST00001
Library . . . . . . . . . . . . . . . . . : SSC
File location . . . . . . . . . . . . . . . : *LCL
Externally described . . . . . . . . . . . : Yes
Number of record formats . . . . . . . . . : 1
Type of file . . . . . . . . . . . . . . . : Physical
SQL file type . . . . . . . . . . . . . . . : TABLE
File creation date . . . . . . . . . . . . : 03/26/12

7.1 of IBM i


Rob Berendt
--
IBM Certified System Administrator - IBM i 6.1
Group Dekko
Dept 1600
Mail to: 2505 Dekko Drive
Garrett, IN 46738
Ship to: Dock 108
6928N 400E
Kendallville, IN 46755
http://www.dekko.com

--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.