Querying multiple member PF with SQL
I would need to SQL on a multiple member PF and I need to query the 2nd or nth member in the PF.  Is this possible just with an SQL query without using OVRDBF etc.?

Answer Question   |  February 15, 2010  8:17 AM
AS/400 SQL, DB2, Physical Files, SQL

Journalling PF in AS400
Hi, I would like to know when a PF is added with some new entries, or the existing entries been modified.  I require a report to be printed with the users and time of update.  How this could be achieved easily?

Answer Question   |  January 13, 2010  12:12 PM
AS/400 journaling, PF, Physical Files

update flat physical file
I have physicle file it cantains following records .I used As400. F1 (colum heading) RRMUNI WPB 3 18 00015 0109 RRMUNI WPB 2 18 00015 0105 RRMUNI WPB 4 18 00015 0107 There are 418 recodrs contain in the file. i want to update RRMUNI as RRMINI using strsql in all the fileds. Pls give [...]

Answer Question   |  January 8, 2010  8:23 AM
Flat Physical Files, Physical Files

Synon/2E, Physical Files
Physical File has RRN as Key. but is this RRN is always Assending or somehow we can make it descending also??

Answer Question   |  February 4, 2010  1:19 PM
Physical Files, Synon/2E

RPG
How do we declare a Physical file for both  input and output(Read/Write/Update) operations in RPG400?

Answer Question   |  December 24, 2009  7:26 AM
Physical Files, RPG, RPG/400

AS/400: concept of Unique key
Hi, I have a PF wiht 3 fields. I  created LF based on this PF, with first 2 fields as Key fields and specify file level key work UNIQUE in that LF. What will happend if I add the duplicate records in PF object…?  

Answer Question   |  December 16, 2009  4:50 AM
AS/400, AS/400 Duplicate Files, Physical Files, Unique key

Working with STRSQL command in AS/400
How to select a particular member from Physical file through STRSQL. Can anyone give me the sample sql statement to access a particular member from Physical file ? Thanks in advance.    

Answer Question   |  October 3, 2011  5:56 AM
Physical Files, STRSQL

How can you pass the parameter to the pf in RPG/400?
How can you pass the parameter to the pf?(using function key 4)

Answer Question   |  December 2, 2009  4:58 AM
AS/400 Parameters, Physical Files, RPG/400

what is the object type of srcpf,pf,lf? (RPG/400)
what is the object type of srcpf,pf,lf?

Answer Question   |  December 2, 2009  4:55 AM
lf, PF, Physical Files, RPG/400, SRCPF

Necessity of a multi-member PF in COBOL
How do we read a multimember PF in cobol ?How does it differ from a regular PF ?

Answer Question   |  November 30, 2009  9:05 AM
COBOL, Physical Files

How to list Journaled files to an Outfile
Hi.  Is there an easy way to get a list that will provide information on which physical files are being journaled within a library?  For some reason, I can not find it, but thought it would be available through one of the DSPFD outfiles, but I haven’t found it, nor have I been able to [...]

Answer Question   |  December 4, 2009  3:05 AM
AS/400 journaling, Outfile, Physical Files

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?

Answer Question   |  April 19, 2012  10:52 AM
DB2/400, Physical Files

data search using popup window
Is there a sample RPG/CL/SQL code on how to create a popup window to search data from a PF?

Answer Question   |  November 17, 2009  12:44 AM
CL, iSeries, Physical Files, RPG, SQL

Reading a file in AS/400
I wanted to read a Physical file based on library. Eg: One master file is available in most of the libraries. I wanted to change some data in that file. So i wanted 2 read file in all the libraies. how to achieve this using program?  

Answer Question   |  November 10, 2009  7:28 AM
Physical Files

Database member Cross reference in Qsys? – Where’s it hidden?
A number of useful objects are in Qsys these days. Items like QADBIFLD are very useful when you want a system wide search for a field. I’ve been looking for the equivalent for file members. Specifically, I want to search for all occurrences of a given file member name across the system’s many libraries/files. Can’t [...]

Answer Question   |  October 8, 2009  10:39 AM
AS/400, i5, iSeries, Physical Files, V5R4

system storage
Can anybody say if i make one pf with following DDs R RECORD    ENAME           20A    ESAL               5S0    EDOB                L        DATFMT(*MDY)                                     DATSEP(‘/’) NOW I AM INITIALIZING 10000 RECORD WITH DEFAULT VALUE BY USING INZPFM COMMAND…. THEN HOW MANY BYTES STORAGE WILL EACH RECORD OR ENTRY OCCUPY.  

Answer Question   |  September 30, 2009  8:47 PM
AS/400 storage, DB2, DB2/400, Physical Files

Diff. between PF and a sql table
can anybody say what is the most basic diff. between making pf by writing DDS and sql table by create table command because both can having index…..

Answer Question   |  October 9, 2009  8:35 PM
DB2/400, DDS, Physical Files, SQL tables

Help!! Physical file accidentally deleted, logicals still there. Is there hope?
I made a HUGE mistake and realized it way too late!! I needed to do a copy of a physical file with *NOMAX on it for the errors because there were 10 corrupted files. Anyway, things went wrong, we restored from backup. Things were back to normal, or so I thought. I got back on [...]

Answer Question   |  October 9, 2009  4:32 AM
Logical Files, Physical Files

Convert spool file to physical file in AS/400
How to convert result file to physical file?

Answer Question   |  April 23, 2012  8:21 AM
AS/400 Spooled Files, Physical Files, Spooled File to Physical File Conversion

IDelete QPFRDATA
Hi, I just want to ask if it is possible to delete the PF (Physical File) inside my performance data library without causing any problem on my AS400 system. I found out that its file is so big.  

Answer Question   |  September 11, 2009  7:57 AM
AS/400, DB2, Physical Files, QPFRDATA