Add a new field in PF
Is it possible to add a new field in an existing PF without deleting the records that are present in it?  

Answer Question   |  March 14, 2013  12:59 PM
Physical Files, RPG

Getting the number of deleted records from Physical file
My requiremnt is to get the number of deleted records from a physical file. This will clear more.When we give DSPFD File name, at bottom we can see the number of records deleted from the so how to pull that field which consist of the value of number of deleted records

Answer Question   |  March 31, 2012  6:18 PM
AS/400, AS400 physical file, DSPFD, Physical Files

How can I retrieve multi-members List to physical files
How can i retrive the Mutli members list to a Physcial file.i tried the below command. i got the error code   DSPFD      FILE(AMLIB/DEMOPF) TYPE(*MBRLIST) +                OUTPUT(*OUTFILE) FILEATR(*PF) +                 OUTFILE(AMLIB/DEMOPF2)                   [...]

Answer Question   |  March 31, 2012  8:18 PM
AS/400 command functions, AS/400 commands, Physical Files

AS/400 PF to IFS with CCSID 935
I have a file on the as/400 which contains mixed language data.  Some fields are coded as ‘O’ to accomodate DBCS Chinese Characters.  This all works fine.  If I pull the data up in Excel using the iseries add in, it comes up great.  I need to take this file and place it on an [...]

Answer Question   |  March 31, 2012  4:20 PM
AS/400 administration, CCSID, IFS, Physical Files

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

Limit to physical files in journal
why we can add only 50PF in a jrnl?i need to create a jrnl for usr who has 65PF in his lib?Plz help me

Answer Question   |  March 31, 2012  10:03 AM
AS/400 journaling, Journal Receivers, Physical Files

What are the steps needs to be followed while removing Key Fields from PF.
Hi, i have got a requirement to remove the Key Fields from the PF. Can anybody please suggest what are all the sequence of steps i shd follow to incorporate this changes to avoid any issues in Production after change. As per my knowledge below are the steps i am planning to follow, please confirm. [...]

Answer Question   |  March 31, 2012  5:43 AM
AS/400 DB2, AS400 physical file, DB2/400, Physical Files

Problem in Changing CCSID
Hi , I am trying to change the CCSID of My physical file from 836 to 937 , but it automatically gets set to 28709 . I am facing the same problem in changing other CCSID sets also.I m using V5R2M0 version of AS400. Please suggest a way to get throgh this problem.    

Answer Question   |  March 31, 2012  9:37 AM
AS400 physical file, CCSID, CCSID in AS400, Physical Files

Deleting the physical files without deleting logical files
Hi, Can anybody tell me how to delete the physical file(PF-DTA) without deleting its dependent files (LF). Actually we are having Mimix running in our live and DR system, in the DR I want to delet PF only and resync with the live.

Answer Question   |  April 4, 2012  10:16 AM
AS400 file changes, Logical Files, MIMIX on iSeries, Physical Files, V5R3

CHGPF doesn’t change the based on LFs
I used the CHGPF command to change the record layout of a Physical File but the based on Logical Files were NOT changed – the Format Level Identifier still had the old value. 

Answer Question   |  July 15, 2011  3:15 PM
CHGPF, i5/OS, Logical Files, Physical Files

Moving the unused source in AS/400
Hi , I want to MOVE unused  sources from source PF . How can avoid copying individual memeber (opt 3) . Is there any coomand like MOVOBJ . I have the list of the sources and the source physical file name . Thanks , Bisht 

Answer Question   |  June 22, 2011  2:12 PM
AS/400 commands, AS400 physical file, Physical Files

Want to delete objects of type ‘File’ except ‘source physical file’
I have taken output of DSPOBJD in a database file. Now I want to delete all the objects having type ‘*FILE’ and object attribute ‘PF’ but the problem is I don’t want to delete ‘Source physical files’. I just want to delete files except ‘Source physical file’. can anybody suggest how to do that ?

Answer Question   |  June 9, 2011  11:07 AM
AS/400 Database File, AS400 physical file, Database Files, DSPOBJD, Physical Files

Journal in AS/400
hi, please help. can someone tell me how to journal my PF file?

Answer Question   |  May 19, 2011  10:25 AM
AS/400 journaling, AS400 physical file, Physical Files

Is there any conflict if create 2 different unit in as400 with the same objects and same ownership.
Is there any conflict if create 2 different unit in as400 with the same objects and same ownership. Are the LF’s will the PF’s dependencies (the LF) will not mixed?

Answer Question   |  March 18, 2011  6:06 AM
AS/400 administration, Logical Files, Physical Files, V5R3

Find AS/400 string
hi all my requirement is find out string that which object contain,that object name,type,libery name,source file name.find all data and store this data into one physical file. physical file contain fields R rec    objname       10A    objType        10A    Libraryname  10A    source-pf      10A Ex:-my string is empdetails this string scan all the objects [...]

Answer Question   |  February 22, 2011  5:49 PM
AS/400, AS400 physical file, Physical Files, String testing

AS/400 Physical File update history
How can we find out the sequence of programs that have updated the fields of the given file. For eg. If I have a file ABC and 10 programs have updated the file ABC, then how can we find out in which sequence the programs have updated the file ABC and what was the value in [...]

Answer Question   |  February 15, 2011  9:15 AM
AS/400, AS400 physical file, Physical Files

AS400 – Physical Files
Hi I have some qusetion in AS400 How can we convert rows into columns and columns into row for a PF in AS400. Please send me the coding for this requirement. Thanks

Answer Question   |  January 22, 2011  11:01 AM
AS/400, AS/400 DB2, Physical Files

OS/400 physical file overridden
Hi, I have two physical files File1 in library 1 and library2. What i am thinking of overriding FileX and FileY to lib1/file1 and lib2/file2 in CLP. In my RPG i am using FileX and FileY and reading records from FileX and writing to FileY. IS this possible?

Answer Question   |  January 18, 2011  11:16 AM
AS/400, OS/400, Physical Files

CPYF thru RRN
CPYF: Copy the records by the keyed sequence.[Br style="padding: 0px; margin: 0px;" />[Br style="padding: 0px; margin: 0px;" />But i want to copy the records in arrival ( RRN ) sequence.[Br style="padding: 0px; margin: 0px;" />[Br style="padding: 0px; margin: 0px;" />Please advice me... I think the work goes here only .... [strong style="padding: 0px; margin: 0px;">Source [...]

Answer Question   |  January 11, 2011  7:09 AM
CPYF, CPYF-RRN, Physical Files, RRN

How to insert records in a physical file using input subfile
have to insert records to a physical file ,the input records should be taken from an input subfile

Answer Question   |  January 6, 2011  7:18 AM
AS/400, AS/400 Records, AS/400 Subfiles, COBOL 400, Physical Files