1
How to get the row count of a PF with RPG ILE?
Hello, I’m looking for an example of how to get a row count of a PF from a ILE rpg program. Thanks everybody.
Answer Question
| December 10, 2008 2:10 AM
AS/400 database, AS/400 development, PF/LF, Physical File, RPG, RPG ILE, RPGILE
Hello, I’m looking for an example of how to get a row count of a PF from a ILE rpg program. Thanks everybody.
How to view online the new data added to a PF?
Hi, I need to display in a subfile the new data added to a phisical file, in real time. Who knows unix, this is something like the command “tail -f”. Thanks a lot!
Answer Question
| December 10, 2008 1:24 AM
AS/400 administration, PF/LF, Physical File, Subfile
Hi, I need to display in a subfile the new data added to a phisical file, in real time. Who knows unix, this is something like the command “tail -f”. Thanks a lot!
AS/400: Unique records in file
hi all, i have a problem , suppose i have a physical file which has multiple occurrences of fld1 , now i need to access that in distinct (one data single time) order. so i created a logical file with UNIQUE keyword . but when i make query on this LF then msg comes that [...]
Answer Question
| December 3, 2008 8:39 AM
AS/400 administration, Logical File, PF/LF, Physical File
hi all, i have a problem , suppose i have a physical file which has multiple occurrences of fld1 , now i need to access that in distinct (one data single time) order. so i created a logical file with UNIQUE keyword . but when i make query on this LF then msg comes that [...]
Display files in AS/400
I am getting stated with RPG400.I hev this requirement to add a new field in an existing screen and move this value to a new PF.This is when the screen is opened in crete mode. the other screen where the new field is to be added is the update screen.In this screen value is to [...]
Answer Question
| November 24, 2008 9:37 AM
AS/400 Display File, Display File, PF/LF, Physical File, Report Program Generator, RPG, RPG/400
I am getting stated with RPG400.I hev this requirement to add a new field in an existing screen and move this value to a new PF.This is when the screen is opened in crete mode. the other screen where the new field is to be added is the update screen.In this screen value is to [...]
Logical file update during FTP
When are the associated logical files updated when a physical file is receiving data via FTP?
Answer Question
| June 14, 2012 8:15 AM
AS/400 FTP, i5/OS, Logical File, PF/LF, Physical File
When are the associated logical files updated when a physical file is receiving data via FTP?
Special character in a PF
Hi, Is there any way to know if a file has any carriage return on any of the records? I have a file which is populated bby front end users and sometimes when they copy paste an item it also picks up the carriage return. any way to find out if file is having any [...]
Answer Question
| September 3, 2010 10:49 PM
Database, iSeries, iSeries database, PF/LF, Physical File
Hi, Is there any way to know if a file has any carriage return on any of the records? I have a file which is populated bby front end users and sometimes when they copy paste an item it also picks up the carriage return. any way to find out if file is having any [...]
reason for getting defaults value?
i have a file p1 (pf) and one one display file d1 whose fields are taken as reference (using f10) from p1 when i write a simple rpgle pgm to write records from display file in to file p1(pf) using following code: fp1 uf a e disk fd1 cf e workstn c *in03 doweq *off [...]
Answer Question
| September 15, 2008 6:31 AM
PF/LF, RPG, RPGLE
i have a file p1 (pf) and one one display file d1 whose fields are taken as reference (using f10) from p1 when i write a simple rpgle pgm to write records from display file in to file p1(pf) using following code: fp1 uf a e disk fd1 cf e workstn c *in03 doweq *off [...]
Create report in RPG for Jounaled PF
Hi Is there quick way to generate report for the changed fields in a jounaled PF. I have a PF which has over 50 fields and need to produce a report if any field is changed or added new value.Thanks
Answer Question
| August 29, 2008 7:23 PM
Journaling (AS/400), PF/LF, RPG
Hi Is there quick way to generate report for the changed fields in a jounaled PF. I have a PF which has over 50 fields and need to produce a report if any field is changed or added new value.Thanks
File Size of a PF in AS/400
How to determine the file size of a a PF in AS/400. Is there a specific CL command which tells us as to how many records a file can store? Or how much more records it can accomodate before its 100% full?
Answer Question
| August 15, 2008 8:05 PM
CL, PF/LF
How to determine the file size of a a PF in AS/400. Is there a specific CL command which tells us as to how many records a file can store? Or how much more records it can accomodate before its 100% full?
how to Move one file(flat file or PF) which is created in a batch job, to the systems C: drive.
how to Move one file(flat file or PF) which is created in a batch job, to the systems C: drive. sing CL
Answer Question
| August 15, 2008 6:09 AM
Batch job, CL, Flat files, PF/LF
how to Move one file(flat file or PF) which is created in a batch job, to the systems C: drive. sing CL
Spool to PF
Is there any way to conver a spool file in a formated physical file with out any codeing. Thanks
Answer Question
| June 18, 2008 7:18 AM
AS/400, PF/LF, Spool files
Is there any way to conver a spool file in a formated physical file with out any codeing. Thanks
why we cant write data to pf using cl program?
y we cant write data to pf using cl program?
Answer Question
| June 29, 2010 6:31 AM
CL, PF/LF
y we cant write data to pf using cl program?
how to update pf using dspf through rpgle
how to update pf using dspf through rpgle
Answer Question
| April 22, 2010 11:55 AM
DSPF, PF/LF, RPGLE
how to update pf using dspf through rpgle
updating pf using simple rpg/400 code.
How can i update a pf using simple rpg code.and please also explain with examples use of setll, chain, setgt, Readc and sflnxtchg?
Answer Question
| June 18, 2008 4:37 AM
CHAIN, EXCPT, PF/LF, RPG, SETLL
How can i update a pf using simple rpg code.and please also explain with examples use of setll, chain, setgt, Readc and sflnxtchg?
two PF have same field
there are two PF, each Pf have same named field, but the length of the field not same. how can i use the field in the program?
Answer Question
| April 19, 2010 1:51 AM
PF/LF, RPG
there are two PF, each Pf have same named field, but the length of the field not same. how can i use the field in the program?
Service Program Parameters Written Directly to PF
I’m taking an old RPG program that does all the writing of records to a PF & converting it to a service program. This should reduce the processing of these records considerably (no more opening & closing the file for each record). I’ve created the service program & tested it, the only problem seems to [...]
Answer Question
| April 28, 2008 7:03 PM
PF/LF, RPG, Service program
I’m taking an old RPG program that does all the writing of records to a PF & converting it to a service program. This should reduce the processing of these records considerably (no more opening & closing the file for each record). I’ve created the service program & tested it, the only problem seems to [...]
serch for reference of PF/LF
Is there any command to find out any perticular PF OR LF used in which RPG program across all libraries and SOURCE PHYSICAL FILES ????
Answer Question
| January 19, 2008 9:58 AM
PF/LF, RPG
Is there any command to find out any perticular PF OR LF used in which RPG program across all libraries and SOURCE PHYSICAL FILES ????
1





