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 find it...

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? Software/Hardware used: AS/400

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? Software/Hardware used: RPG, CL, SQL, iSeries

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?  

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

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

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

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 the system a couple...

Convert spool file to physical file in AS/400

How to convert result file to physical file? Software/Hardware used: As400

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.  

Can i declare a display file and a physical file in a single CL

Can i declare a display file and a physical file in a single CL.  Also can u share a sample program, which uses the parameters entered in the display file (using SNDRCV command) and processes records from a physical file.

writing record to a file through CLLE

Can we write a record to the physical file using CLLE?

Synon/2E

Hello, Let’s say my physical file has 1000 records, and I want to read 500th directly. Is this possible in Synon 2E? If possible can anyone explain me the way to implement it? Thanks & Regards Bibin George