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
- 35943 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 |
What are Triggers?
14 Answers Ordain Solutions, Seabus Solutions,
Why we have multiple data types in As400 and why we use numeric, packed, decimal, zoned the basic difference between this?
what is rpg ?
What is the difference between Physical and Logical files ?
What is the purpose of PR and PI in calling program and called program? in Called program PR is compulsory?
Define an Interactive Job?
which of the following operations does not zero the field flda defined as 4,0?
HOW CAN WE ENTIRE OBJECTS& IT'S TYPE IN PGM?
during input operation which indicator position is seton if there is a record lock?
what the purpose of ovrdta, ovrata keywords?
What is Spool file, Why is it required?
name few ibm supplied libraries?
RPG400 
