MIDRANGE dot COM Mailing List Archive



Home » MIDRANGE-L » June 2014

Re: CPYTOIMPF



fixed

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.







Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2014 by MIDRANGE dot 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 here. If you have questions about this, please contact