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
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
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
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
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
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
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?(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?
Answer Question | December 2, 2009 4:55 AM
lf, PF, Physical Files, RPG/400, SRCPF
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
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 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
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
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
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
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
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
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
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
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