Re: CPYTOIMPF error CPDA09B - CCSID conversion could not be performed.

["Peter Dow" <pcdow@xxxxxxxxx>]

Hi Everyone,

I've only received one response to this question, so I guess I'd like
someone who's using QNTC to try copying a source member from their AS400 to
a directory in QNTC, e.g.

CPYTOIMPF FROMFILE(lib/srcf srcmbr) TOSTMF('/QNTC/Users/Reporting/test.txt')
RCDDLM(*CRLF)

When I try it, it fails with

File QACP909313 created in library QTEMP.
Member QACP909313 added to file QACP909313 in QTEMP.
QCP_libsrcfsrcmbr in PDOW type *FILE not found.
Error Occurred in SQL Call Level Interface
CCSID conversion could not be performed.
No records copied from file SRCF in LIB.
Object QACP909313 in QTEMP type *FILE deleted.
Copy command ended because of error.

While a source physical file is one of the allowed types for the FROMFILE
parameter, when I try something similar with a data file, e.g.

CPYTOIMPF FROMFILE(LIB/DATAF) TOSTMF('\QNTC\Users\Reporting\909313.CSV')
RCDDLM(*CRLF)

I get

File QACP909313 created in library QTEMP.
Member QACP909313 added to file QACP909313 in QTEMP.
CCSID conversion could not be performed.
No records copied from file DATAF in LIB.
Object QACP909313 in QTEMP type *FILE deleted.
Copy command ended because of error.

The machine is running V4R4 and is current on PTF's afaik.

If anyone is able to do this successfully, I would appreciate hearing about
it.

If either of the above fails, try something like this instead:

CPYTOIMPF FROMFILE(LIB/DATAF) TOSTMF('/home/dataf.txt) RCDDLM(*CRLF)

[which gave me the following results]
File QACP909313 created in library QTEMP.
Member QACP909313 added to file QACP909313 in QTEMP.
Database file member copied to object.
All records copied from file DATAF in LIB.
Object QACP909313 in QTEMP type *FILE deleted.

then

CPY OBJ('/home/dataf.txt') TODIR('/QNTC/Users/Reporting/') TOCODEPAGE(1252)
DTAFMT(*TEXT)

[which said]
Object copied.

The resulting file in /QNTC has a codepage (as reported by WRKLNK opt.8) of
1252.


Thanks in advance!
Peter Dow
Dow Software Services, Inc.
909 425-0194 voice
909 425-0196 fax


> +---
> | This is the Midrange System Mailing List!
> | To submit a new message, send your mail to MIDRANGE-L@midrange.com.
> | To subscribe to this list send email to MIDRANGE-L-SUB@midrange.com.
> | To unsubscribe from this list send email to
MIDRANGE-L-UNSUB@midrange.com.
> | Questions should be directed to the list owner/operator:
david@midrange.com
> +---


_________________________________________________________
Do You Yahoo!?
Get your free @yahoo.com address at http://mail.yahoo.com

+---
| This is the Midrange System Mailing List!
| To submit a new message, send your mail to MIDRANGE-L@midrange.com.
| To subscribe to this list send email to MIDRANGE-L-SUB@midrange.com.
| To unsubscribe from this list send email to MIDRANGE-L-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator: david@midrange.com
+---