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.
- Start BTEQ.
- 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.
- Perform the following steps in order.
- .EXPORT FILE = file_name
- SELECT DelTable
FROM systemfe.CleanupQCF
ORDER BY SeqNumber;
- EXPORT RESET;
- .RUN FILE = file_name
where file_name is the name of the file you create to contain the output of the SELECT request.