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
- 36379 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 |
when are the unique constraints executed?
give three main purposes of file specification ?
what if my system I runs with system value qccsid 65535?
what is the function of crtdupobj command?
when should I use method get, and when should I use method post in my cgis?
define what a data queue is along with a brief example of what it may be used for?
What is the purpose of STRCMTCTL command?
what is the rpg and cl life cycle?Please tell me any body
maximum number of subfiles that can defined in a rpg program for one display file is?
can a join logical file be updated?
what are activation group and what are its types.?
what is the purpose of the indara keyword?
RPG400 
