• CPYTOIMPF problems since V5R3 – need workaround

    Researching I have found that apparently there are translation problems with CPYTOIMPF since V5R3. I've seen a couple of suggested work arounds but none seem to work for one reason or other. I'm trying to copy an externally defined data file into a CSV ASCII file. In the past I've simply written an...

    LDB45 pointsBadges:
  • Question on CPYTOIMPF performance

    I create 2 programs, both of which use CPYTOIMPF to format a list of AS400 PFs to character delimited files. The difference between them is: one formats files to qtemp(PGM A), while the other one formats files to a library other than qtemp(PGM B). I called the 2 program separately to format about...

    Paranoiawire25 pointsBadges:
  • copying to a folder with .zip extention

    Is it possible to use CPYTOIMPF to copy file to a folder with the .zip extention

    Dliila5 pointsBadges:
  • Does CPYTOIMPF honor keys of a FROMFILE logical file?

    Does CPYTOIMPF command honor keys of a logical file?

    DWatk5 pointsBadges:
  • 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) +...

    MayraPR5 pointsBadges:
  • 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?

    JMShmc5 pointsBadges:
  • 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??

    AS400 - Ask the Expert485 pointsBadges:
  • 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...

    StreetD35 pointsBadges:
  • 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 possible...

    Chrisjam95 pointsBadges:
  • 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 anyone...

    VGP300 pointsBadges:
  • 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 .

    Chrisjam95 pointsBadges:
  • 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 expanded...

    GarySouders10 pointsBadges:
  • 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?!?!

    Jtagg10 pointsBadges:
  • 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

    Ambrish 82310 pointsBadges:
  • 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...

    VRSTEEL5 pointsBadges:
  • 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...

    Jasingle20 pointsBadges:
  • 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...

    Mattheus55 pointsBadges:
  • last field needs a terminator character

    adding FLDDLM character between fields but I need terminator at end of last field, how can I do It ??

    Pasqua5 pointsBadges:
  • CPYTOIMPF and EXCEL defaults

    I have an issue when copying an AS400 file to the IFS. One field that is defined as 15 charachter and contains numeric data does not show up in .csv format correctly without reformatting the column to special. I also tried defining the field as numeric, and had the same result. Example of data...

    Sbarnes5 pointsBadges:
  • Problem with delimiter in CPYTOIMPF

    I have used pipe symbol | as the delimiter to seperate fields.I used this in a DS and moved it to a flat file.From the flat file CPYTOIMPF was used to created a text file and ftpd.The problem is that the | symbol is read as ! in another system.Wat could be the reason

    0 pointsBadges:

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following