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 [...]

Answer Question   |  April 19, 2013  7:09 AM
AS/400, Physical File

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.

Answer Question   |  April 2, 2013  2:59 PM
Physical File, RPGLE, RPGLE files

Creating physical files
What command would I use to create a physical file?

Answer Question   |  February 28, 2013  9:36 PM
AS/400, Physical File

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 defining the record structures. [...]

Answer Question   |  February 11, 2013  8:14 AM
AS/400, Physical File

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.

Answer Question   |  February 1, 2013  3:06 PM
DDS, Physical File

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 FROMSTMF(‘/Interfaces/OCSEA/RS671WF@’) + TOFILE(RS671WFI) MBROPT(*ADD) + STMFLEN(2046) FROMCCSID(819) [...]

Answer Question   |  January 28, 2013  5:27 PM
AS/400, CPYFRMIMPF, Physical File

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

Answer Question   |  January 24, 2013  6:37 AM
AS/400, Physical File

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 [...]

Answer Question   |  January 10, 2013  6:31 AM
AS/400, CSV, Physical File

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

Answer Question   |  November 28, 2012  7:25 AM
AS/400, Physical File

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.

Answer Question   |  November 7, 2012  5:11 PM
AS 400, DB2/400, Physical File

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 [...]

Answer Question   |  October 2, 2012  3:23 PM
AS400 Command, DB2/400, Physical File

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

Answer Question   |  September 18, 2012  8:51 AM
Physical File, RPG

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

Answer Question   |  August 24, 2012  5:55 AM
keyword, Physical File

AS/400
how to insert(add) a negative value or number to physical file record ?

Answer Question   |  July 24, 2012  7:31 AM
Physical File

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?

Answer Question   |  March 31, 2012  6:25 AM
AS/400 journaling, AS400 physical file, PF, Physical File

physicalfile records updation in subfile
i have created one subfile and records are also dsplayed ,but i want modify one record three times but i want second time modification record value ,so how to acess that record value?       please give me example program and subfile desion.

Answer Question   |  July 9, 2011  1:34 PM
AS/400, Physical File, RPGLE, Subfile

Store data in physical file
i have a pf name is emp,in this not unique key,so i am enter duplicates records in that pf,now i want to find out the what records are repeated eno that record find out after store into other file,how to do

Answer Question   |  May 2, 2011  12:21 PM
AS/400, AS400 physical file, Data storage management, Physical File

How to delete physical file member?
I tried to delete physical file member in AS/400 by using CLRPFM command…but nothing get deleted…why?

Answer Question   |  August 15, 2011  8:48 AM
AS400 physical file, Clear Physical File Member, CLRPFM, Physical File

Updating the column heading of a Physical File
Is it possible to update the column heading’s of PF in an RPGLE program ?

Answer Question   |  December 30, 2010  7:47 PM
AS/400, Physical File, RPGLE

Open query file selecting records(qryslt)
This is my Physical file ‘EMPS’ existing in library “TAMIL1″ and its record format is ‘EMPRCD” a)its source is R EMPRCD                    ENO            4  0       ENAME         10          EADD         [...]

Answer Question   |  December 9, 2010  8:17 AM
AS400/OPNQRYF, Open Query, Open Query File, Physical File, QRYSLT, V5R3