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
- 36744 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 would the ALL keyword be used?
which are the string manipulation opcodes?
difference between sflrcdnbr and sflnxtchg?
What are all the different types of access path?
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.
What is the difference between keys of a Physical file and the keys of a logical file?
2 Answers Bank Of America, BoA,
how can you detect and handle a record lock situation?
What are the different opcodes used for file operation on a subfile in a rpg pgm?
What is a job log?
define the purpose of the *bcat function?
how a varible can be passed to a subfile...accnt1 contain data in a data area..ie Daccnt1 uds,Daccnt2 3 overlay(accnt1:1), DNo 4 overlay(accnt1:4)..we want to transfer this dataarea value from acnt0001 to a subfile..that means to enter each record we have to incriment account no,, i normal window we can do move accnt1 account_no eval account_no=accnt1 eval no=no+1 exfmt usr_account how it possible with Subfile????????.Please do answer? (Thank you for all your answers dear friends!!)
at what level s,o are defined and what they will do?
RPG400 
