How we can delete all the Logical File of a Physical file
in one instance ?
- 9 Answers
- 34379 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 is a Library in AS/400?
What are the valid user defined data area types?
what is command in SFTP which is equivalent to SDUP command in FTP?
how can you specify no duplicate key?
what are the types of errors available in rpg IV or 400.Like decimal data error,sessional error or device error etc...means important error occurings,ie to find out suddenly???pls give answ if u know?Pls give the answer 1,,,,,,,to 12.........ie how it will happened like...for eg if a file is not closiing ,,,like this error is happened... if sufficient data is not in a pf to write in a display file. or sfldsp is not "on"......sessional or device error occured...like this give details all 1 to 12 errors (syam..)....give details PLsssssssssss?
how can I control from my cgis the cache of a remote browser?
Q.Hi All friends, I have one Question, I have three fields in display file SUP LOT, ISSUED to Prod and Line Grp. Field SUP LOT is mentioned in one field reference file WRSLT and key field as a key field LP.Fields ISSUED to PROD,Line GRP are mentioned in the another Field reference file WMDTF. So I want to read SUP LOT on the basis of key field LP from the first file WFSLTand then i want ot read another two fields ISSUED to DATE and LINE GRP from second file on the basis of SUP LOT, which i got from first file.Now i want to display these fields in the display file DSPWMMS. but Condition is that 'Supplier Lot,ISSUED to Prod and Line Grp will not be shown if their respective fields are blanks/Zero. Please Let me Know coding part of this senerio and what would be coding for display file to now shown fields if fields are blanks/zero. My mob. no. is 9836300345. Please reply me asap.
OVRDBF FILE(xxx) TOFILE(libl/filename) share(*yes) In which scenario is share(*yes) used? could any one explain with an example?
Feedback about ELI Faridabad.
Hi friends.. i want to be a IBM MainFrame Professional.. can any body tell me what is requirement for that... i m just BA, MA, and have simple diploma in Computers. what is pre-requisite.
when should I use method get, and when should I use method post in my cgis?
What is array in as400? What are the types of array?
RPG400 
