1
  • Using CPYTOIMPF to copy records from a physical file to an Excel book

    CPYTOIMPF FROMFILE(SARKNS/ENQP003) TOSTMF('C:/Documents and Settings/user/exc.xls') MBROPT(*REPLACE) RCDDLM(*LF) DTAFMT(*iso) Here I have created an 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 run...

    Chrisjam95 pointsBadges:
  • CPYTOIMPF error code 7

    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 complete for reason code 7. What should I do?

    Kapiltiwari350 pointsBadges:
  • 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 working correctly until we recently...

    SallyMackay15 pointsBadges:
  • Command to copy database file to folder in AS/400?

    AS400

    Srikanth75 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:
  • CL – Copy To Import File

    I am using the CPYTOIMPF fromfile(PF) to STMF('dir\acp&txtfile') where &txtfile is &curdt *tcat &curtm.(system date and time) The stream file is created as acp&txtfile and what i want is acp120108100150.

    0 pointsBadges:
  • TXT file naming using CL

    Hi I hve created a txt file from a pf using cpytoimpf.The name of the txt file should have ccyymmddhhmmss in its name.I can retreive the date and time parameters from qdate and qtime.How do i name the txt file using a CL.

    0 pointsBadges:
1

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