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

How can we arrange duplicate records in a file?

791


what does opcode post do ?

1390


How can we change the uppercase to Lowercase in RPG?

1109


when would you prefer logical file than opnqryf?

1809


how can a message from a message file appear as a constant on the screen?

1224


what is service program?

780


define the purpose of the %sst function?

1266


what is sflpag and sflsiz ?

2821


name few ibm supplied libraries?

1605


What is difference between rename and prefix?

781


What is a query can be displayed without saving it?

867


Why we are not able to perform insert delete and update operation in Join logical file?

1176


how to run other job when one job is active?

775


What is diff between EVAL & MOVE?

1187


What are the types of data structure in as400?

759