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