• CPYF Command in AS/400

    Hi, I have two files (A,B) with different definitions (Column names,data type,length etc) are different. Both are on same AS/400 system. Now I want to copy all the records from FILEA to FILEB. What I want to say is, COPY data from one file to another file, where nothing is common in between them....

    HABBIE895 pointsBadges:
  • How to create a single member file for each member of a given multi-member file?

    Let the file be 'Employee' and its members be 'Trainee', 'Associate', 'Professional', and 'Expert'. I wish to cut the superset of 'Employee', and just get dedicated PFs for 'Trainee', 'Associate', 'Professional' and 'Expert' (so that they can be queried as a first member.)

    rajat01195 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:
  • Reading IFS file from CL program

    I have a requirement of reading a IFS file from CL program. As far as I know there is no direct way of achieving this. I am planning ot use CPYFRMSTMF followed by CPYF to copy the IFS file first as a memeber and then as a database file. Is there any better way to achieve this? Regards Sudip

    Raju40060 pointsBadges:
  • Copy multiple PF’s from a QSYS.LIB to IFS Share Folder

    How do I copy multiple DB files in a single call from a QSYS.LIB to IFS Shared PC FOLDER on iSeries P& OS400 7.1

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

    sivakesava285 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

    NicyChn140 pointsBadges:

    What is the actual difference between CPYF and CRTDUPOBJ

    MAGIC205 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...

    22917560 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?

    22917560 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:

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.

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