CPYTOIMPF

copying to a folder with .zip extention

Is it possible to use CPYTOIMPF to copy file to a folder with the .zip extention Software/Hardware used: Iseries

CCSID for South Africa

Is there a specific CCSID that need to be used for South Africa? We are running AS/400 V5R4.

Getting error when converting file to csv format using CPYTOIMPF

I am trying to convert a data file to csv format using command CPYTOIMPF. The data file cotains fields with type "O" (DBCS-Open data) and I received an error. Error id CPF2845 Code 1. How to resolve this problem? command used: CPYTOIMPF  FROMFILE(&LIB/&FILE &MBR) TOSTMF(&STMF) +...

CPYTOIMPF data corruption

CPYTOIMPF on V5R4 with latest PTF's adds invalid data to the created CSV file for some blank fields in the PF. Is this a Bug? Software/Hardware used: AS/400 V5R4

Does CPYTOIMPF honor keys of a FROMFILE logical file?

Does CPYTOIMPF command honor keys of a logical file? Software/Hardware used: As/400

CPYTOIMPF

i am new to as400 and i wanted to transfer file from as400 to pc using CPYTOIPMF as per advised here. BUt i am receiving an error File system error occurred. Error number 3025. whats wrong? thanks

FTP a file to AS/400 from a PC command line

How do I transfer(FTP) a file(pf of savf) from PC command line? Wanna know the process..I tried several times using CPYTOSTMF and CPYTOIMPF but that file resides in the AS400 IFS..How to transfer from there??

ISeries Data Transfer VS CPYTOIMPF

When transfering data from the AS400 to a PC as a text file using the iSeries transfer, the numeric values are right justified and this is what I need. I am trying to setup a CL that will do this with out any user interaction. But whenever I try to do this on the AS400 using CPYTOIMPF or CPYTOSTMF...

How can I copy records from a Physical file to Excel Sheet ?

I would like to know about copying records from a physical File to Excel sheet , Can any one brief me in this regards ? Eg: I have a PF called ATMLIB/ATMTRA. EXC.XLS is a Excel Book . Now this is the situation . I am working on V4R4M0. I would like to know on this version whether it can be...

CPYTOIMPF

CPYTOIMPF FROMFILE(SARKNS/ENQP003) TOSTMF('C:/Documents and Settings/user/exc.xls') MBROPT(*REPLACE) RCDDLM(*LF) DTAFMT(*iso) Here I have created a Excel book with name exc.xls , my requirement is to copy all the records from my physical file (sarkns/enqp003) to the desired excel book. when i...

cpytoimpf CSV file showing garbage

I have an application that does 3 CSV files to import to Excel. All three use the same cpytoimpf program/command, 1 is working correctly and 2 are not. I debugged and do not see a difference. I can view the data just fine with dsplnk on the iSeries/AS/400 but the Excel is all @@@@@@. Does...

How can I convert all the records from a Physical File to Exces ?

I would like to know how can I achieve this ? and I am working on V4R4. Example : PF1 contains 100 records , I need to convert this into Exces .

AS/400 data mapping with CPYFRMIMPF

We have an application in which we need to expand the size of several fields within the record, ie the Amount field need to be larger. In the past I would create DDS for the new expanded file, create the file, then write an RPG or Cobol program to copy the data from the old file to the new...

CPYTOIMPF v5r2 problem when STMFCODPAG(*STMF) parm used

Here's the command... CPYTOIMPF FROMFILE(LIB/FILE MEMBER) TOSTMF('\PATH\FILE_20090421.txt') RCDDLM(*CRLF) STRDLM(*NONE) FLDDLM('|') ERROR "No records copied from file" but if I use parm STMFCODPAG(*PCASCII) it copies fixed length w/ delimiters and I need stream w/ delimiters... can anyone help?!?!

Difference between CPYTOIMPF and CPYF command

hi, I am working on AS400- RPGILE can anybody please tell me whet is the difference between command CPYTOIMPF an CPYF I would really appreciate if you explane with example. Thanks & Regards Ambrish

CPYTOIMPF --FLDDLM(*TAB) QUESTION

Our OS is V5R4. I am using cpytoimpf to import .txt file (tab delimited) to DB2 physical file. If I remove the FLDDLM(*TAB), I get all the records but the fields have overlapped data. If I use the (*TAB) I get one record and errors on the remaining copy.(error code 7) Here is the command I am...

CPYTOIMPF

When i enter this command i find this error. CPYFRMIMPF FROMSTMF('/new_recon_conv.csv') TOFILE(NAVNEET/TT4 TT4) MBROPT( *REPLACE) RCDDLM(*CRLF) STRDLM('"') FLDDLM('|') DATFMT(*USA) RPLNULLVAL(*F LDDFT) The copy did not...

CPYTOIMPF - PC .TXT file displaying as 'garbage'

Hi, We are using a simple CPYTOIMPF command to move a Physical file to the IFS in a .TXT format. CPYTOIMPF FROMFILE(S4CMREP) TOSTMF(&TOIMPTF) + MBROPT(*REPLACE) RCDDLM(*CRLF) + STRDLM(*NONE) FLDDLM(*TAB) Where &TOIMPTF is a IFS Folder & file name. This was...

My CL program is running CPYTOIMPF cmd & causes an SQL error

Message Id: SQ999999 Error occurred in SQL Call Level Interface. A procedure call encountered an error. The error code is 10. When I F1 on the line in the job log and then F9 for details, I see this: From program QSQCLI in QSYS, module SQLSEA, procedure SQLSetEnvAttr at stmt 5793 and To program...

CPYTOIMPF and multiple record formats

I have four different files with four different record formats which need to be copied into one file with alternating record formats, (rec fmt #1, rec fmt#2, rec fmt#3 rec fmt #4 in that order). The file also has to be field delimited with pipes, and so I thought CPYTOIMPF would work, but I am...