How to delete a schema by using db2 -tvf file.sql command?

[Neville]

I want to delete a schema using just one command.

there are many object are dependent objects like triggers,views and tables on this schema.

can i prepare a single file which contains all the commands and it deletes all the objects followed by the schema.

So can anyone tell me the steps to follow?

[Neville]

Ya i got it and providing a solution here.

Scenario:Suppose there is one schema as TEMP and this schema having the object table as T1,T2 i.e. TEMP.T1 & TEMP.T2

now i want to delete the schema TEST and if i fire a command as:

db2 DROP SCHEMA TEMP RESTRICT;

it will give me an error as

SQL0478N DROP, ALTER, TRANSFER OWNERSHIP or REVOKE on object type "SCHEMA" cannot be processed because there is an object "TEMP.T1","TEMP.T2". of type "TABLE".
which depends on it. SQLSTAE=42893

so solution to this i have to fire three commands through CLP.

so i can create a file and write the commands as

DROP TABLE TEMP.T1;
DROP TABLE TEMP.T2;

DROP SCHEMA TEMP RESTRICT;

and save the file as DROP_TEMP.sql and then fire a single command as

db2 -tvf DROP_TEMP.sql

it will drop the tables and followed by the schema.


Thank you all.