• Check the record counts of a physical file from single system which exists on 2 systems.

    Hi. I have a PF which exists on 2 different systems. The systems are in replication using MIMIX. During DR drill (system role swap) we are comparing the record counts of some PFs. For comparison we are using "SQL Interactive Sessions". Is there a way to get the record counts of these PFs which are...

    Ketan19305 pointsBadges:
  • Add a field in existing file in DB2/400

    I need add a field in existing Physical file without impacting any other file? I know the CHGPF command but I'm not sure about which parameter needs to be update. Please advice.

    Askt265 pointsBadges:
  • Source physical files in a library

    I would like to know what are the source physical files in my Library. Is there any command for this? I have used some command in my previous project. But couldn't remember it..Can anyone help on this?

    NAN4AS40095 pointsBadges:
  • SETLL

    Hi, I want to read a physical file sequentially. The physical file has no key. I use SETLL and READ. *LOVAL is not allowed when I use SETLL (because no key in the pf?) so I set a 1 in factor 1. 1 SETLL READ 90 *IN90 IFEQ *ON ... Is this ok? When I have a key in the file could I then use the...

    withcareandsoon5 pointsBadges:
  • NULL value in physical file

    I am a beginner in AS/400 and learning through some tutorials, I came with a problem of how to add a NULL value in physical file. The spaces can't do the work, as even spaces have a ASCII value. Please respond with possible solutions.

    Durgesh813370 pointsBadges:
  • About files

    I have a physical file and a logical file, on that physical file in a library and now I want to copy the object of that physical and logical file to another library. I copied the object of the physical file to another library which happened good but when I am copying the object of the logical file...

    JSDHFKJHA335 pointsBadges:
  • Performance improvement for building access path for LF/ Copying Data to PF

    Dear Experts, I have a installation process. Which will install the Objects (including PF & LF) to client environment. Our Existing process will work in this manner. 1. Install Physical File 2. Copy the Data to Physical File from Archive. 3. Copy the Logical Files. As all the process will be...

    deepu93214,290 pointsBadges:
  • How to use SETLL and READE to solve this program

    I have to write those records in PF whose criteria is as follows: * [b] C - [/b] = 'y' * [b] record must be latest for particular id [/b]here is the data - pf name - FILEA (to be read) and FILEB ( to be write) [b] A B C [/B] 10 1 N 11 1 Y 11 2 Y * 13 1 N 14 1 N 14 2 Y 14 3 Y * 15 1 Y * I have to...

    rpglecodingusingas400115 pointsBadges:
  • 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,475 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:

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