• 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,410 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:
  • Limit to physical files in journal

    why we can add only 50PF in a jrnl?i need to create a jrnl for usr who has 65PF in his lib?Plz help me

    Rajasekhar151,395 pointsBadges:
  • Physical File record length

    how to change PF record length?

    Rajasekhar151,395 pointsBadges:
  • AS/400 PF to IFS with CCSID 935

    I have a file on the as/400 which contains mixed language data.  Some fields are coded as 'O' to accomodate DBCS Chinese Characters.  This all works fine.  If I pull the data up in Excel using the iseries add in, it comes up great.  I need to take this file and place it on an IFS to be...

    GirlScout10 pointsBadges:
  • How can I retrieve multi-members List to physical files

    How can i retrive the Mutli members list to a Physcial file.i tried the below command. i got the error code   DSPFD      FILE(AMLIB/DEMOPF) TYPE(*MBRLIST) +                OUTPUT(*OUTFILE) FILEATR(*PF) +                 OUTFILE(AMLIB/DEMOPF2)                        ...

    Progrmmer5 pointsBadges:
  • Programs using a PF

    how can we see that what are all the programs that uses a single PF? is that possible to see it?

    Rajasekhar151,395 pointsBadges:
  • Getting the number of deleted records from Physical file

    My requiremnt is to get the number of deleted records from a physical file. This will clear more.When we give DSPFD File name, at bottom we can see the number of records deleted from the so how to pull that field which consist of the value of number of deleted records

    ankit2002770 pointsBadges:
  • ftping entire source physical file

    Dear All, How to do ftping for entire source physical file which is having different members types to other enviornment so that in that enviornment (say Production) that members could be opened in edit mode. Thanks  

    6r1,520 pointsBadges:
  • Reading physical file in reverse order by rpg/400 program

    Dear all, How to read a physical file in reverse order by rpg/400 program,condition is there is not any key field in this file. Thanks

    6r1,520 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