How we can delete all the Logical File of a Physical file
in one instance ?

Answer Posted / 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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

what is message file?

606


what is elastic and non elastic subrile?

569


why do we use readc? What is sflnxtchg?

676


what is rpg ?

955


which are the query selection criteria, which can be given in a query?

680






which indicator is used for read?

636


what is a program described file in rpg?

1064


when would you use or not use this approach?

903


what does check opcode is used?

979


what are different record spacing keywords in rlu ?

1224


What Is The Object Type Of Pf, Lf, Printer File & Display File?

711


what is the purpose of putovr (put with explicit override) keyword?

945


hi guys i am new for sqlrpgle, please suggest me good websites and theory and coding. plz plz its very urgent.

2139


what is the syntax for plist?

657


which are the relational operators in rpg?

679