Help with CpyToStmf
Last Post 05 Feb 2013 03:56 PM by Brian Rusch. 4 Replies.
AddThis - Bookmarking and Sharing Button Printer Friendly
  •  
  •  
  •  
  •  
  •  
Sort:
PrevPrev NextNext
You are not authorized to post a reply.
Author Messages
gio.cot
Basic Member
Basic Member
Posts:267

--
05 Feb 2013 09:43 AM

Hi all

i see that this problem has been discussed a lot of times, however I don't sincerely have well understands what the solution could be

if i run this command:

CPYTOSTMF FROMMBR('/QSYS.LIB/qgpl.LIB/myfileFILE/myfile  
                  .MBR')                                     
          TOSTMF('/QNTC/192.168.0.28/myflr/INVOI 
                 C_FLAT_20130205145647.txt')                 
          STMFOPT(*REPLACE)                                  
          STMFCCSID(*STDASCII)

i receive the error CPDA09B not been possible to perform the conversion CCSID

CCSID of my file is 65535  and i read that this CCSID is the problem; is it possible create e file with a different CCSID ?  i tried to change my CCSID JOB and then run CRTPF FILE(QTEMP/MYFILE) RCDLEN(124) but the CCSID is always 65535 .

which work around to solve this problem ?

Thanks in advance

 

 

 

Brian Rusch
Advanced Member
Advanced Member
Posts:548

--
05 Feb 2013 09:52 AM
You could expicitly specify the database file CCSID with the DBFCCSID parameter on the CPYTOSTMF command.
gio.cot
Basic Member
Basic Member
Posts:267

--
05 Feb 2013 10:30 AM

Hi thanks for your reply

anyway  i tried  with DBFCCSID = 65535 but this value is not allowed !!!!

 

 

 

Crispin
Veteran Member
Veteran Member
Posts:1492

--
05 Feb 2013 11:04 AM
Program described files can only have a CCSID of 65535. Create a DDS or DDL description for the file with a single text field and use that...
Brian Rusch
Advanced Member
Advanced Member
Posts:548

--
05 Feb 2013 03:56 PM
>> i tried with DBFCCSID = 65535 but this value is not allowed !!!!

No, I meant specify the CCSID of the data in the physical file in the command. If the data is EBCDIC, then the CCSID is usually 37, so your command would look like this:

CPYTOSTMF FROMMBR('/QSYS.LIB/qgpl.LIB/myfile.FILE/myfile.MBR')
TOSTMF('/QNTC/192.168.0.28/myflr/INVOIC_FLAT_20130205145647.txt')
STMFOPT(*REPLACE) STMFCCSID(*STDASCII) DBFCCSID(37)
You are not authorized to post a reply.

Acceptable Use Policy