• Single record selection out of multiple records by using CPYF command

    In my physical file i have multiple records with same data. Now i want to use the CPYF command to copy only single record which was last updated in the file. I searched all the options in CPYF command but i didn't get anything related to it. Please advice on this. I am using this procedure in CL...

    sivakesava240 pointsBadges:
  • CPYF command

    I'm running multiple jobs one by one. each job is writing data into one particular(A) file. Next doing coping the data into B from A And data is cleared from A file One job Again same is repeating couple of times each job. Finally I want to copy the data from B to A all the records. The order of B...

    gaganas40 pointsBadges:
  • CPYF alternative

    Hi, One of out Auto start job is locking a file (A). (triggers are used and it is designed like that only) And another program which copies the file (B) in to (A) by CPYF is going to MSGW, telling the object is locked. How we can overcome this...are there any alternate solutions to copy that file?

    Anu143525 pointsBadges:
  • CPYF

    Is there any way to create a new physical file(say PF2) with same structure/fields as in a logical file(say LF1, whose physical file is PF1). One way is to use CPYF to create PF2 from LF1 but I dont wan't any data to be copied from LF1 to PF2 (dont want to use clrpfm after copying data) Is there...

    anuppdas105 pointsBadges:
  • AS400 Logical Files

    i have copied a LF using CPYF command. When I use wrkobj LFname i can find the object but when i use wrkobj PFname(of the previous LF) object is not present. How can i copy PF and that particular LF when i give LF name in copy Command

    NicyChn75 pointsBadges:
  • CPYF and CRTDUPOBJ

    What is the actual difference between CPYF and CRTDUPOBJ

    MAGIC205 pointsBadges:
  • how to copy tables between two libraries without repeat cpyf command using script?

    I need to copy tables from library to another on the same iSeries v7.1, is there a script to copy multible tables without repeat cpyf command???

    HBlue5 pointsBadges:
  • I want to delete records from a PF outside a PGM

    I need to either setup a SQL that lets me pass a variable so that I can delete records based on a moving date. Or, I want to setup a CPYF command that will allow me to copy records that are *LT a variable (date). I'm not sure how to pass variable to either idea.

    TIB5 pointsBadges:
  • CPYF thru RRN

    CPYF: Copy the records by the keyed sequence.[Br style="padding: 0px; margin: 0px;" />[Br style="padding: 0px; margin: 0px;" />But i want to copy the records in arrival ( RRN ) sequence.[Br style="padding: 0px; margin: 0px;" />[Br style="padding: 0px; margin: 0px;" />Please advice me... I think the...

    22917510 pointsBadges:
  • Command to copy physical files before they get deleted

    I have a requirement that when DLTF file command is execued if the file is PF then before file gets deleted CPYF coomand should be run.[Br style="padding: 0px; margin: 0px;" />[Br style="padding: 0px; margin: 0px;" />How can this be done?

    22917510 pointsBadges:
  • cpyf and cpysplf: How to copy spool files and database files in AS/400?

    Hi, Can you give me the what are the steps to copy the data from one pf to another pf using cpyf? and how to copy the data from spool file to database file using cpysplf?  

    Girilabs130 pointsBadges:
  • CPYF w/INCREL copying too many records

    I'm using the following command: CPYF FROMFILE(REIDATA/DESGDTL) TOFILE(ISJN/DESG73133) MBROPT(*ADD) INCREL((*IF DSDID *EQ '73133')) ... in the file I am ending up with records containing both '73133' and '73133-1' in the file.  The field DSDID is the primary key to the file.  In summary it is...

    JamesR90 pointsBadges:
  • CPYF selecting a record by a variable

    Hi friends, I have a CL and I dont know how making a cpyf selecting records with a variable, like this example: 5722SS1 V5R3M0 040528 Control Language DLTOLDSPLF/CARGA TDBSBC14 04/06/08 19:54:32 Page 1 Program . . . . . . . . . . . . . . . . . . . : CARGA Library . . . . . . . . . . . . . . . . . ....

    SILVARB440 pointsBadges:
  • Faster File copy mechanism- Want to copy a huge data from one AS/400 file to another AS/400 file.

    I want to copy a huge data from one AS/400 file to another AS/400 file. This is copying on the same machine. I tried a CPYF command first. It takes about 45 minutes to copy that file. Next, I tried the SAVE to a SAVF and restore from this SAVF. It takes about 20 minutes now. I would like to know if...

    Rsm5 pointsBadges:
  • cpyf problem

    Hello, we have the following problem: in August 2007 we bought an i5 520 with V5R4. The i5 should be much faster than the old machine, because the hardware is much bigger than the old hardware. We copied the software from the old machine (V5R2) to the new i5. The programs are all working fine but:...

    Jogisarge30 pointsBadges:
  • cpyf on multiple files

    i need to copy all of the records from all of the files in one libray to a diff libray (add the records - joning two lib's into one - how can I do this with out running the job 3000+ times

    Kkgoldi15 pointsBadges:
  • Cpyf and *NOCHK

    I am trying to convert characters to numbers (in a field) using the cpyf, but it doesn't work. I am using 2 files, the 1 has characters fields, the 2 has numbers fields

    Efra5005 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:
  • CPY an IFS file from one directory to another

    I have a file in a folder on the IFS -we will call the folder MYFILES and the file is FILEA. I want to copy a duplicate of the file to folder YOURFILES with the name FILEA. The command is: CPY OBJ('/MYFILES/FILEA.csv') TOOBJ('YOURFILES/FILEA.csv') REPLACE(*YES) I get the following error: CPFA0A9...

    docorp15 pointsBadges:
  • must reorganize huge file over thanksgiving

    We have a file with 4 million active records and 200 million deleted records , I want to reorganize on Thanksgiving. Plan is to copy out (cpyf) , clrpfm, then copy back (cpyf). My question is will the 'clrpfm' run for hours ??

    DAIRYPGMR20 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