Procedure Using BTEQ
Perform the following procedure to drop the tables for the query capture database using BTEQ. The procedure assumes that you have already created QCF_database_name. This procedure does not drop the views and macros on the specified QCD.
1 Start BTEQ.
2 Change your current database to the database from which the QCF tables are to be dropped as follows.
DATABASE QCD_database_name;
where QCD_database_name is the name of the database you created for the QCD tables.
3 Perform the following steps in order.
a .EXPORT FILE = file_name
b SELECT DelTableFROM systemfe.CleanupQCFORDER BY SeqNumber;
c EXPORT RESET;
d .RUN FILE = file_name
where file_name is the name of the file you create to contain the output of the SELECT request in step c.