Delete Physical file member data (selected)
I have a physical file in AS/400 machine which has a member which contains history data. I tried to delete few records from the member using SQL statement. but there is no place to enter the member name in the SQL statement. So I need to know a method to delete few selected records in [...]

Answer Question   |  September 12, 2012  10:12 AM
AS/400, AS400 physical file

compare physical file
can any one tell me how to compare two phisical files in AS400? Can it be done thrugh some query statement?

Answer Question   |  June 20, 2012  3:36 PM
AS/400, AS400 physical file

AS/400 database
which command is used to find out the total number of records in physical file? i heard there are 4 ways… 1. dspfd 2.  ?????? 3.  ?????? 4.  ?????? can you please share with me ?….

Answer Question   |  June 13, 2012  7:25 AM
AS/400, AS400 physical file

AS/400
as 400

Answer Question   |  July 28, 2012  5:37 AM
AS/400, AS400 physical file

AS/400 COBOL
one physical file have 6 key fields,now i want to retrive the 10th record based on one key field,how to retrive in cobol/400 with without using logical file ex:- emp pf have 6 key fields,and emp have records,now i want to retrive particular record in emp(10 th record only),in my cobol pgm some times use [...]

Answer Question   |  March 31, 2012  10:07 AM
AS/400, AS400 physical file, COBOL/400

AS400 COBOL one pf have one lf but key fields are different
i have one physical file,that pf have one logical file,but pf have 4 key fields,logical file have 2 key fields,now both(pf,lf) are using in cobol/400 code   SELECT pf-file ASSIGN TO DATABASE-pf1 [Br _extended=”true” />ACCESS IS dynamic[Br _extended=”true” />ORGANIZATION IS INDEXED [Br _extended=”true” />RECORD KEY IS EXTERNALLY-DESCRIBED-KEY [Br _extended=”true” />FILE STATUS IS pf-STATUS. [Br _extended=”true” />[Br [...]

Answer Question   |  March 31, 2012  11:30 AM
AS/400, AS400 physical file, COBOL, COBOL/400

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

Programs using a PF
how can we see that what are all the programs that uses a single PF? is that possible to see it?

Answer Question   |  March 31, 2012  6:25 AM
AS/400 journaling, AS400 physical file, PF, Physical File

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

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

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

Store data in physical file
i have a pf name is emp,in this not unique key,so i am enter duplicates records in that pf,now i want to find out the what records are repeated eno that record find out after store into other file,how to do

Answer Question   |  May 2, 2011  12:21 PM
AS/400, AS400 physical file, Data storage management, Physical File

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

Question on Physical Files & Logical Files
Hi Group, I have a Physical file. I created a Logical file on it with a key field as Primary key. Later as per the new requirements i created a LF with composite key as primary key. Should i make any changes to the LF that was created earlier??

Answer Question   |  May 18, 2011  8:28 AM
AS/400, AS400 physical file, DB2/400, Logical Files

How to delete physical file member?
I tried to delete physical file member in AS/400 by using CLRPFM command…but nothing get deleted…why?

Answer Question   |  August 15, 2011  8:48 AM
AS400 physical file, Clear Physical File Member, CLRPFM, Physical File

Mask a password in as400
how to mask a password with asteric which is retrieved from a physical file in rpgle(as400)

Answer Question   |  March 11, 2011  9:58 AM
AS/400 passwords, AS400 physical file, RPGLE Program

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