• Updating a physical file

    Suppose I have a RPGLE Program P1 And P2 and a physical file PF1 . P1 using PF1 in update mode and p2 also using Pf1 in update mode. When P1 calls P2, it throws an error saying file locked. What can be done. I need to update pf1 in both the progs.

    jainamit380 pointsBadges:
  • Add a new field in PF

    Is it possible to add a new field in an existing PF without deleting the records that are present in it?

    jainamit380 pointsBadges:
  • Creating physical files

    What command would I use to create a physical file?

    Marbri20 pointsBadges:
  • Significance of record format in physical file

    What is the main significance of Record format while defining a physical file or logical file. that is while defining the physical file we specify the record format. In some situations we also use file name as record format, and sometimes we use the different names other than file names for...

    sivakesava285 pointsBadges:
  • Duplicate records in a keyed physical file

    Would journaling over a multiple member physical file cause duplicate records? The DDS of the file does not have UNIQUE.

    Mcrews25 pointsBadges:
  • CPYFRMIMPF returning blank records

    I am using CPYFRMIMPF to copy a flat text file to an AS/400 physical file. The copy is occurring, but the records are blank. The physical file contains the correct number of records after the copy, but the data is blank. Below is the command with parms. CPYFRMIMPF...

    cavecreek5 pointsBadges:
  • Physical file

    While compiling physical file, it is submitted to Batch. I don't want to submit to Batch. Please give me a solution.

    421380 pointsBadges:
  • Problem with the READ from PF in RPGLE

    Hi ! Im trying to read a physical file from my RPGLE program. That physical file having many fileds. AGCDE is the one of the filed there. The AGCDE data is from 001 to 700. But i just added it randomly. Now im having a problem with READ in RPGLE.. When i call the program its reading the Physical...

    Sureyz2,655 pointsBadges:
  • How to know whether the CSV extraction to PF happened today

    I have a requirement like this. I have 2 separate program which is called as part of daily job. I need to extract a CSV data onto an AS/400 physical file and this file is being used in both the programs. I need to put the call to extract the CSV in any of the 2 program and have to check in the...

    RamvishakRamesh2,505 pointsBadges:
  • How to use more than one key field in CHAIN opcode

    I have a physical file it contains three key fields how to use all three key fields in CHAIN opcode

    gsivakkp86225 pointsBadges:
  • Alternative name of Physical file

    How to rename an alternative name(long name) in a physical file using sql or any other method.(Alternative name if present can be found using DSPFD) . No source is available for this physical file and only object is available.

    anuppdas105 pointsBadges:
  • How to reduce the time taken to select the records from huge keyed physical file having 180 Million records

    Hi All, I have a report program which uses the OPNQRYF to select the records to generate a report based on user selection in display screen, but it is taking lot of time (20 to 30 minuates) to select the records and write write into output file. I am accessing keyed logical file based on physical...

    Mohan K695 pointsBadges:
  • How to copy records from physical to another physical file.

    Hi, I have a question when i seen my requirement. I have two physical files and one RPG program. What I need is, I want to write RPG code for " Copy updated records from one physical file to another physical file" . (Another physical file is for Backup Purpose. ) Regards Surya P

    SURYAP300 pointsBadges:
  • AS/400

    What is the use of INZPFM? Why we need that? Surey..

    Sureyz2,655 pointsBadges:
  • QDBSRV04/05 reorg running for 31 hours and still going…

    During monthly maintenance we submitted a reorg of a file: -RGZPFM FILE(MM410LIB/INVAUD) ALWCANCEL(*YES) LOCK(*SHRUPD) The reorg was canceled after running 15 hours. Now the PF and first logical file are being reindexed under the QDBSRC04/05 jobs (there are a total of 8 logicals). When executing...

    Christieth20 pointsBadges:
  • Logical file update during FTP

    When are the associated logical files updated when a physical file is receiving data via FTP?

    Chandlerbing81840 pointsBadges:
  • how to copy column-headings from a PF

    how to get column-heading names copied along with data from a PF to a flat-file? - OR - how to copy column-headings from a PF to another PF?

    svankipu620 pointsBadges:
  • Read backword in CL/400

    How to read backword a physical file in CL400.

    Bdchow5 pointsBadges:
  • Problem in Changing CCSID

    Hi , I am trying to change the CCSID of My physical file from 836 to 937 , but it automatically gets set to 28709 . I am facing the same problem in changing other CCSID sets also.I m using V5R2M0 version of AS400. Please suggest a way to get throgh this problem.    

    TcsEmployee5 pointsBadges:
  • What are the steps needs to be followed while removing Key Fields from PF.

    Hi, i have got a requirement to remove the Key Fields from the PF. Can anybody please suggest what are all the sequence of steps i shd follow to incorporate this changes to avoid any issues in Production after change. As per my knowledge below are the steps i am planning to follow, please confirm....

    Mohan K695 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.