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
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 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
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
how to change PF record length?
Answer Question | March 31, 2012 12:27 PM
AS/400 file specification, AS400 physical file, Physical Files
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
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
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
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
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
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
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
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. 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
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
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
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
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: 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
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