Restrict File Size created by WRKQRY
How to restrict file size created using RUNQRY ? e.g. Created the query using WRKQRY to join 2 transaction file and output type selected is databasefile. We don’t have the exact primary key to relate 2 files, hence we are not sure about the no. of transaction expected from this query. Can we restrict the output file [...]

Answer Question   |  March 31, 2012  5:39 AM
AS/400, AS/400 file specification, RUNQRY, WRKQRY

Physical File record length
how to change PF record length?

Answer Question   |  March 31, 2012  12:27 PM
AS/400 file specification, AS400 physical file, Physical Files

Problem in updating a IFS file content..
Hi , i have a text file in IFS which have some data. Now after reading i want to replace all occurance of xyz with abc and update the ifs file .Everything is working fine except updation . The problem is with pointer setting , everytime the data is appended in file rather than replacing [...]

Answer Question   |  March 31, 2012  3:41 PM
AS/400 file specification, IFS, IFS Commands, RPGLE

How to find the Multi Member File in As400 System?
How to find the Multi Member File in As400 System?

Answer Question   |  April 17, 2011  8:53 AM
AS/400 File Extract, AS/400 file specification, Multi-Member

AS400 – DB2 file names
Given a view name, how will i find its physical file name… e.g. my view name is EMP_TMP_TPL_HDR Thanks, NG

Answer Question   |  September 15, 2009  2:12 PM
AS/400, AS/400 file specification, DB2

AS/400 file specification
Why sometimes we need to put “K” for file specification?eg: FSSDATA IF E K DISK

Answer Question   |  November 17, 2008  6:18 AM
AS/400 file specification, FSSDATA parameter, RPG, RPGLE