Interested to Buy Any Domain ? << Click Here >> for more details...
How we can delete all the Logical File of a Physical file
in one instance ?
- 9 Answers
- 36036 Views
- IBM, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / gaurav
There is no such command for deleting all LF at one shot
Create CL program for this
| Is This Answer Correct ? | 25 Yes | 3 No |
Answer / anonymous- projo
You create a CL program using following tips
1. pass file name as a parameter.
2. Declare a Model DSPDBR outfile
3. Execute DSPDBR command and store the results in out file
declared in step 2.
4. Read this file to retrieve all file names in loop one
after another deleting each one.
| Is This Answer Correct ? | 18 Yes | 2 No |
Answer / amit kumar
Hi Every body ,
One command exists.
Use CHGPF with Delete dependent logical file - *Yes
Give source file with your physical file other wise you
will not be able see this option.
Thanks.
| Is This Answer Correct ? | 13 Yes | 4 No |
Answer / abhishek
Hi Friends,
There is no command which directly deletes all the
depandent logical.
Regarding use of option delete dependant file under CHGPF:
Consider example below:
Lets say PF has 3 fields... Fld1, Fld2 & Fld3
First LF has key field as Fld1.
Second LF has key field as Fld2
1. Pl note that delete dependant file option will only come
when you specify the source name and libr along with object
name & libr.
2. Lets say, I have removed one of the field named Fld2
from my PF. Obviously, my second LF is of no use, as field
use by this file is removed. Now, if I specify, DELETE
DEPENDANT FILES as *YES under CHGPF command, it will first
change my PF properties (as expected) and will also delete
SECOND LOGICAL FILE (as it has a dependant field).
Hope, it helps. Cheers.
| Is This Answer Correct ? | 5 Yes | 1 No |
Answer / omer ozen
run the following sql:
drop table <filename> cascade;
And all the logicals based on the file being deleted will
magically disappear.
| Is This Answer Correct ? | 4 Yes | 0 No |
Answer / pravin
Use CHGPF with Delete dependent logical file - *Yes
but it deletes only when u delete or remove those fields
from the pf which are used in lf
| Is This Answer Correct ? | 7 Yes | 4 No |
Answer / vineet bhardwaj
hello,
yes we can delete all lf which is associate to one pf thru
chgpf commond but we have to give the source file name also
then we get the option delete dependent lf will be *yes.
...
| Is This Answer Correct ? | 1 Yes | 1 No |
i have copied a pf from another one and after updating that
pf ,i used it in my program.It was giving me an error.
After compiling the program i have found that it was
refering to previous record name.
Then in command line in CHGPF i mentioned program name and
source file name.
you will get 'Delete dependent logical file' option,make
it '*yes'.
That is how i deleted all the references.
| Is This Answer Correct ? | 0 Yes | 0 No |
Answer / kavitha s
Use CHGPF with Delete dependent logical file - *Yes
| Is This Answer Correct ? | 7 Yes | 23 No |
Dear All, I have one confusion related to my platform. I am working with Wipro from last two year however still I am looking for AS400 platform kindly show me the way out of it. And please share with me the hardware knowledge that how I grow myself in hardware (AS/400) also.
why we sometimes use same file name in FILE and TOFILE in OVRDBF and sometimes different??please tell
how do handle file exception/error?
how do u compile rpgle program?
What is the necessary keyword used in a physical file to refer field definitions from the field reference file?
What do you mean by ODP?
what are the limitations of cl (compare to rpg) ?
what are the different types of keys in AS400
what is the purpose of data structure?
can anybody give the interview questions list of RLU. plz mail me: dinesh_sati07@yahoo.com
What process the command SBMRJEJOB does?
diffrence between rename and prefix
RPG400 
