Re: CPYTOIMPF

[John McKee <jmmckee@xxxxxxxxxxxxxx>]

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.