echo off
cls
echo *******************************************************************************
echo ** 
echo **   Author     : Vinay Bagare
echo **   Purpose    : Generates drop and create statements for all the tables
echo **                specified in a particular parent db
echo **   Parameter  : Database Name (All children under this database)
echo **   Assumption : 
echo **   Program    : GenStat.Bat
echo **   
echo *******************************************************************************

TITLE GenerateStats R1.0 for Windows NT

SET HOME_GenStat=C:\Vindoc\UTILITY\GenStats


IF "%1" == "" %HOME_GenStat%\scripts\out.bat
IF "%2" == "" %HOME_GenStat%\scripts\out.bat
sleep 1

cls
ECHO *******************************************************************************************************************
ECHO ****
ECHO ****                  STEP 1: Remove Old Files
ECHO ****
ECHO *******************************************************************************************************************


IF EXIST %HOME_GenStat%\scripts\Chk_DB.bat       DEL %HOME_GenStat%\scripts\Chk_DB.bat
IF EXIST %HOME_GenStat%\scripts\Chk_Tbl.bat      DEL %HOME_GenStat%\scripts\Chk_Tbl.bat
IF EXIST %HOME_GenStat%\log\*.log                DEL %HOME_GenStat%\log\*.log.
IF EXIST %HOME_GenStat%\scripts\Chk_DBObj.bteq   DEL %HOME_GenStat%\scripts\Chk_DBObj.bteq
IF EXIST %HOME_GenStat%\scripts\Chk_tbl.bteq     DEL %HOME_GenStat%\scripts\Chk_tbl.bteq
IF EXIST %HOME_GenStat%\scripts\Chk_Meta.bteq    DEL %HOME_GenStat%\scripts\Chk_Meta.bteq    
IF EXIST %HOME_GenStat%\file\%2.txt              DEL %HOME_GenStat%\file\%2.txt 
IF EXIST %HOME_GenStat%\file\stat.txt            DEL %HOME_GenStat%\file\stat.txt 
IF EXIST %HOME_GenStat%\scripts\GenStat.bteq     DEL %HOME_GenStat%\scripts\GenStat.bteq
IF EXIST %HOME_GenStat%\scripts\Drop_Meta.bteq   DEL %HOME_GenStat%\scripts\Drop_Meta.bteq




echo. > %HOME_GenStat%\scripts\Chk_Tbl.bat 
echo. > %HOME_GenStat%\scripts\Chk_DB.bat

sleep 2
cls
ECHO *******************************************************************************************************************
ECHO ****
ECHO ****                  STEP 2: Check if Tables and Databases exists - First step Checks for DB, next table
ECHO ****
ECHO *******************************************************************************************************************
ECHO.                                                                             >> %HOME_GenStat%\scripts\Chk_DBObj.bteq 
TYPE  %HOME_GenStat%\logon\logon.txt                                              >> %HOME_GenStat%\scripts\Chk_DBObj.bteq 
ECHO.                                                                             >> %HOME_GenStat%\scripts\Chk_DBObj.bteq 
ECHO SEL * FROM DBC.Databases                                                     >> %HOME_GenStat%\scripts\Chk_DBObj.bteq 
ECHO WHERE DatabaseName = '%1';                                                   >> %HOME_GenStat%\scripts\Chk_DBObj.bteq                   
ECHO.                                                                             >> %HOME_GenStat%\scripts\Chk_DBObj.bteq 
ECHO .if activitycount = 0 THEN .os ECHO DB ^>  %HOME_GenStat%\scripts\Chk_DB.bat >> %HOME_GenStat%\scripts\Chk_DBObj.bteq 
ECHO.                                                                             >> %HOME_GenStat%\scripts\Chk_DBObj.bteq 
ECHO .LOGOFF                                                                      >> %HOME_GenStat%\scripts\Chk_DBObj.bteq 
ECHO .QUIT                                                                        >> %HOME_GenStat%\scripts\Chk_DBObj.bteq 

BTEQ < %HOME_GenStat%\scripts\Chk_DBObj.bteq > %HOME_GenStat%\log\Chk_DBObj.log
for /f %%x in (%HOME_GenStat%\scripts\Chk_DB.bat) do CALL %HOME_GenStat%\scripts\DB.bat %%x %1 %2



ECHO.                                                                             >> %HOME_GenStat%\scripts\Chk_tbl.bteq 
TYPE  %HOME_GenStat%\logon\logon.txt                                              >> %HOME_GenStat%\scripts\Chk_tbl.bteq 
ECHO.                                                                             >> %HOME_GenStat%\scripts\Chk_tbl.bteq 
ECHO SEL * FROM DBC.Tables                                                        >> %HOME_GenStat%\scripts\Chk_tbl.bteq 
ECHO WHERE DatabaseName = '%1'                                                    >> %HOME_GenStat%\scripts\Chk_tbl.bteq                   
ECHO AND TableName    = '%2';                                                     >> %HOME_GenStat%\scripts\Chk_tbl.bteq                   

ECHO .if activitycount = 0 THEN .os ECHO TBL ^>  %HOME_GenStat%\scripts\Chk_Tbl.bat >> %HOME_GenStat%\scripts\Chk_tbl.bteq 
ECHO.                                                                             >> %HOME_GenStat%\scripts\Chk_tbl.bteq 
ECHO .LOGOFF;                                                                     >> %HOME_GenStat%\scripts\Chk_tbl.bteq 
ECHO .QUIT;                                                                       >> %HOME_GenStat%\scripts\Chk_tbl.bteq 

BTEQ < %HOME_GenStat%\scripts\Chk_tbl.bteq > %HOME_GenStat%\log\Chk_tbl.log
for /f %%x in (%HOME_GenStat%\scripts\Chk_Tbl.bat) do CALL %HOME_GenStat%\scripts\TBL.bat %%x %1 %2

cls
ECHO *******************************************************************************************************************
ECHO ****
ECHO ****                  STEP 3: Check if Metadata tables exist - Drop and Create
ECHO ****
ECHO *******************************************************************************************************************
ECHO.                                                                             >> %HOME_GenStat%\scripts\Chk_Meta.bteq 
TYPE  %HOME_GenStat%\logon\logon.txt                                              >> %HOME_GenStat%\scripts\Chk_Meta.bteq 
ECHO.                                                                             >> %HOME_GenStat%\scripts\Chk_Meta.bteq 
ECHO SEL * FROM DBC.Tables WHERE DatabaseName = '%1' AND TableName = 'STATS_STG'; >> %HOME_GenStat%\scripts\Chk_Meta.bteq 
ECHO.                                                                             >> %HOME_GenStat%\scripts\Chk_Meta.bteq 
ECHO .if activitycount ^> 0 THEN DROP TABLE %1.STATS_STG;                         >> %HOME_GenStat%\scripts\Chk_Meta.bteq    
ECHO CREATE MULTISET TABLE %1.STATS_STG(                                          >> %HOME_GenStat%\scripts\Chk_Meta.bteq                                            
ECHO IN_LineTxt VARCHAR(600))                                                     >> %HOME_GenStat%\scripts\Chk_Meta.bteq                                                       
ECHO PRIMARY INDEX (IN_LineTxt);                                                  >> %HOME_GenStat%\scripts\Chk_Meta.bteq 
ECHO.                                                                             >> %HOME_GenStat%\scripts\Chk_Meta.bteq    
ECHO SEL * FROM DBC.Tables WHERE DatabaseName = '%1' AND TableName = 'STATS_INFO';>> %HOME_GenStat%\scripts\Chk_Meta.bteq 
ECHO.                                                                             >> %HOME_GenStat%\scripts\Chk_Meta.bteq    
ECHO .if activitycount ^> 0 THEN DROP TABLE %1.STATS_INFO;                        >> %HOME_GenStat%\scripts\Chk_Meta.bteq    
ECHO CREATE MULTISET TABLE %1.STATS_INFO (                                        >> %HOME_GenStat%\scripts\Chk_Meta.bteq    
ECHO       STATS_DTE     DATE FORMAT 'YY/MM/DD'                                   >> %HOME_GenStat%\scripts\Chk_Meta.bteq    
ECHO       ,STATS_TIME   CHAR(8)                                                  >> %HOME_GenStat%\scripts\Chk_Meta.bteq    
ECHO       ,UNIQUE_VAL   INT                                                      >> %HOME_GenStat%\scripts\Chk_Meta.bteq    
ECHO       ,COLUMN_LIST  VARCHAR(600))                                            >> %HOME_GenStat%\scripts\Chk_Meta.bteq    
ECHO PRIMARY INDEX(STATS_DTE, STATS_TIME, COLUMN_LIST);                           >> %HOME_GenStat%\scripts\Chk_Meta.bteq    
ECHO.                                                                             >> %HOME_GenStat%\scripts\Chk_Meta.bteq    
ECHO.                                                                             >> %HOME_GenStat%\scripts\Chk_Meta.bteq    
ECHO SEL * FROM DBC.Tables WHERE DatabaseName ='%1' AND TableName = 'TargetTable';>> %HOME_GenStat%\scripts\Chk_Meta.bteq 
ECHO.                                                                             >> %HOME_GenStat%\scripts\Chk_Meta.bteq    
ECHO .if activitycount ^> 0 THEN DROP TABLE %1.TargetTable;                       >> %HOME_GenStat%\scripts\Chk_Meta.bteq    
ECHO CREATE SET  TABLE %1.TargetTable (                                           >> %HOME_GenStat%\scripts\Chk_Meta.bteq    
ECHO       DatabaseName CHAR(30),                                                 >> %HOME_GenStat%\scripts\Chk_Meta.bteq    
ECHO       TableName    CHAR(30))                                                 >> %HOME_GenStat%\scripts\Chk_Meta.bteq    
ECHO PRIMARY INDEX(DatabaseName, TableName);                                      >> %HOME_GenStat%\scripts\Chk_Meta.bteq    
ECHO.                                                                             >> %HOME_GenStat%\scripts\Chk_Meta.bteq    
ECHO.                                                                             >> %HOME_GenStat%\scripts\Chk_Meta.bteq    
ECHO INSERT INTO %1.TargetTable VALUES ('%1', '%2');                              >> %HOME_GenStat%\scripts\Chk_Meta.bteq    
ECHO.                                                                             >> %HOME_GenStat%\scripts\Chk_Meta.bteq    
ECHO .LOGOFF;                                                                     >> %HOME_GenStat%\scripts\Chk_Meta.bteq 
ECHO .QUIT;                                                                       >> %HOME_GenStat%\scripts\Chk_Meta.bteq 


BTEQ < %HOME_GenStat%\scripts\Chk_Meta.bteq  > %HOME_GenStat%\log\Chk_Meta.log
cls
ECHO *******************************************************************************************************************
ECHO ****
ECHO ****                  STEP 4: Check if Metadata tables exist - Drop and Create
ECHO ****
ECHO *******************************************************************************************************************

TYPE  %HOME_GenStat%\logon\logon.txt                                              >> %HOME_GenStat%\scripts\GenStat.bteq
ECHO .SET SIDETITLES On;                                                          >> %HOME_GenStat%\scripts\GenStat.bteq
ECHO .SET foldline Off;                                                           >> %HOME_GenStat%\scripts\GenStat.bteq
ECHO .SET errorout stdout;                                                        >> %HOME_GenStat%\scripts\GenStat.bteq
ECHO .SET WIDTH 500;                                                              >> %HOME_GenStat%\scripts\GenStat.bteq
ECHO .SET FORMAT OFF;                                                             >> %HOME_GenStat%\scripts\GenStat.bteq
ECHO .SET TITLEDASHES OFF;                                                        >> %HOME_GenStat%\scripts\GenStat.bteq
ECHO .SET ERRORLEVEL 3624 SEVERITY 0                                              >> %HOME_GenStat%\scripts\GenStat.bteq
ECHO.                                                                             >> %HOME_GenStat%\scripts\GenStat.bteq
ECHO .EXPORT REPORT FILE = %HOME_GenStat%\file\stat.txt                           >> %HOME_GenStat%\scripts\GenStat.bteq
ECHO.                                                                             >> %HOME_GenStat%\scripts\GenStat.bteq
ECHO Database %1;                                                                 >> %HOME_GenStat%\scripts\GenStat.bteq
ECHO HELP STATS %1.%2;                                                            >> %HOME_GenStat%\scripts\GenStat.bteq
ECHO .EXPORT RESET                                                                >> %HOME_GenStat%\scripts\GenStat.bteq
ECHO.                                                                             >> %HOME_GenStat%\scripts\GenStat.bteq
ECHO.                                                                             >> %HOME_GenStat%\scripts\GenStat.bteq
ECHO .IMPORT VARTEXT FILE = %HOME_GenStat%\file\stat.txt                          >> %HOME_GenStat%\scripts\GenStat.bteq
ECHO .REPEAT *                                                                    >> %HOME_GenStat%\scripts\GenStat.bteq
ECHO.                                                                             >> %HOME_GenStat%\scripts\GenStat.bteq
ECHO USING	(IN_LineTxt VARCHAR(500))                                         >> %HOME_GenStat%\scripts\GenStat.bteq
ECHO.                                                                             >> %HOME_GenStat%\scripts\GenStat.bteq
ECHO INSERT INTO %1.STATS_STG (IN_LineTxt)                                        >> %HOME_GenStat%\scripts\GenStat.bteq
ECHO VALUES                (:IN_LineTxt);                                         >> %HOME_GenStat%\scripts\GenStat.bteq
ECHO.                                                                             >> %HOME_GenStat%\scripts\GenStat.bteq
ECHO INSERT INTO %1.STATS_INFO                                                    >> %HOME_GenStat%\scripts\GenStat.bteq
ECHO SEL CAST((SUBSTRING(IN_LineTxt FROM 6 FOR 8)) AS DATE FORMAT 'YY/MM/DD')  AS STATS_DTE >> %HOME_GenStat%\scripts\GenStat.bteq
ECHO ,SUBSTRING(IN_LineTxt FROM 20 FOR 8) AS STATS_TIME                           >> %HOME_GenStat%\scripts\GenStat.bteq
ECHO ,SUBSTRING(IN_LineTxt FROM 42 FOR 21)  AS UNIQUE_VAL                         >> %HOME_GenStat%\scripts\GenStat.bteq
ECHO ,TRIM(SUBSTRING(IN_LineTxt FROM 76 FOR 400)) AS COLUMN_list                  >> %HOME_GenStat%\scripts\GenStat.bteq
ECHO FROM %1.STATS_STG;                                                           >> %HOME_GenStat%\scripts\GenStat.bteq
ECHO.                                                                             >> %HOME_GenStat%\scripts\GenStat.bteq
ECHO.                                                                             >> %HOME_GenStat%\scripts\GenStat.bteq
ECHO.                                                                             >> %HOME_GenStat%\scripts\GenStat.bteq
ECHO.                                                                             >> %HOME_GenStat%\scripts\GenStat.bteq
ECHO .EXPORT REPORT FILE %HOME_GenStat%\file\%2.txt                               >> %HOME_GenStat%\scripts\GenStat.bteq
ECHO.                                                                             >> %HOME_GenStat%\scripts\GenStat.bteq
ECHO.                                                                             >> %HOME_GenStat%\scripts\GenStat.bteq
ECHO.                                                                             >> %HOME_GenStat%\scripts\GenStat.bteq
ECHO .SET TITLEDASHES OFF;                                                        >> %HOME_GenStat%\scripts\GenStat.bteq
ECHO .SET WIDTH 500;                                                              >> %HOME_GenStat%\scripts\GenStat.bteq
ECHO.                                                                             >> %HOME_GenStat%\scripts\GenStat.bteq
ECHO.                                                                             >> %HOME_GenStat%\scripts\GenStat.bteq
ECHO Database %1;                                                                 >> %HOME_GenStat%\scripts\GenStat.bteq
ECHO.                                                                             >> %HOME_GenStat%\scripts\GenStat.bteq
ECHO SEL                                                                          >> %HOME_GenStat%\scripts\GenStat.bteq
ECHO CASE WHEN DBC_Ind.DatabaseName IS NOT NULL THEN 'COLLECT STATS ON ' ^|^| DBC_Ind.DatabaseName ^|^| '.' ^|^| DBC_Ind.TableName ^|^| ' INDEX(' ^|^| Column_List ^|^| ');'      >> %HOME_GenStat%\scripts\GenStat.bteq
ECHO ELSE  'COLLECT STATS ON ' ^|^| TRIM(TT1.DatabaseName) ^|^| '.' ^|^| TRIM(TT1.TableName) ^|^| ' COLUMN(' ^|^| Column_List ^|^| ');'                                           >> %HOME_GenStat%\scripts\GenStat.bteq
ECHO.                                                                             >> %HOME_GenStat%\scripts\GenStat.bteq
ECHO END (TITLE '')                                                               >> %HOME_GenStat%\scripts\GenStat.bteq
ECHO.                                                                             >> %HOME_GenStat%\scripts\GenStat.bteq
ECHO FROM                                                                         >> %HOME_GenStat%\scripts\GenStat.bteq
ECHO 	(SEL TRIM(IND.DatabaseName) AS DatabaseName                               >> %HOME_GenStat%\scripts\GenStat.bteq
ECHO 	      ,TRIM(IND.TableName) AS TableName                                   >> %HOME_GenStat%\scripts\GenStat.bteq

ECHO 	      ,TRIM(MAX(CASE WHEN ColumnPosition = 1  THEN TRIM(ColumnName) ELSE '' END) ^|^|        >> %HOME_GenStat%\scripts\GenStat.bteq
ECHO 	       MAX(CASE WHEN ColumnPosition = 2  THEN ','  ^|^| TRIM(ColumnName) ELSE '' END) ^|^|   >> %HOME_GenStat%\scripts\GenStat.bteq
ECHO 	       MAX(CASE WHEN ColumnPosition = 3  THEN ','  ^|^| TRIM(ColumnName) ELSE '' END) ^|^|   >> %HOME_GenStat%\scripts\GenStat.bteq
ECHO 	       MAX(CASE WHEN ColumnPosition = 4  THEN ','  ^|^| TRIM(ColumnName) ELSE '' END) ^|^|   >> %HOME_GenStat%\scripts\GenStat.bteq
ECHO 	       MAX(CASE WHEN ColumnPosition = 5  THEN ','  ^|^| TRIM(ColumnName) ELSE '' END) ^|^|   >> %HOME_GenStat%\scripts\GenStat.bteq
ECHO 	       MAX(CASE WHEN ColumnPosition = 6  THEN ','  ^|^| TRIM(ColumnName) ELSE '' END) ^|^|   >> %HOME_GenStat%\scripts\GenStat.bteq
ECHO 	       MAX(CASE WHEN ColumnPosition = 7  THEN ','  ^|^| TRIM(ColumnName) ELSE '' END) ^|^|   >> %HOME_GenStat%\scripts\GenStat.bteq
ECHO 	       MAX(CASE WHEN ColumnPosition = 8  THEN ','  ^|^| TRIM(ColumnName) ELSE '' END) ^|^|   >> %HOME_GenStat%\scripts\GenStat.bteq
ECHO 	       MAX(CASE WHEN ColumnPosition = 9  THEN ','  ^|^| TRIM(ColumnName) ELSE '' END) ^|^|   >> %HOME_GenStat%\scripts\GenStat.bteq
ECHO 	       MAX(CASE WHEN ColumnPosition = 10 THEN ','  ^|^| TRIM(ColumnName) ELSE '' END) ^|^|   >> %HOME_GenStat%\scripts\GenStat.bteq
ECHO 	       MAX(CASE WHEN ColumnPosition = 11 THEN ','  ^|^| TRIM(ColumnName) ELSE '' END) ^|^|   >> %HOME_GenStat%\scripts\GenStat.bteq
ECHO 	       MAX(CASE WHEN ColumnPosition = 12 THEN ','  ^|^| TRIM(ColumnName) ELSE '' END) ^|^|   >> %HOME_GenStat%\scripts\GenStat.bteq
ECHO 	       MAX(CASE WHEN ColumnPosition = 13 THEN ','  ^|^| TRIM(ColumnName) ELSE '' END) ^|^|   >> %HOME_GenStat%\scripts\GenStat.bteq
ECHO 	       MAX(CASE WHEN ColumnPosition = 14 THEN ','  ^|^| TRIM(ColumnName) ELSE '' END) ^|^|   >> %HOME_GenStat%\scripts\GenStat.bteq
ECHO 	       MAX(CASE WHEN ColumnPosition = 15 THEN ','  ^|^| TRIM(ColumnName) ELSE '' END) ^|^|   >> %HOME_GenStat%\scripts\GenStat.bteq
ECHO 	       MAX(CASE WHEN ColumnPosition = 16 THEN ','  ^|^| TRIM(ColumnName) ELSE '' END) ^|^|   >> %HOME_GenStat%\scripts\GenStat.bteq
ECHO 	       MAX(CASE WHEN ColumnPosition = 17 THEN ','  ^|^| TRIM(ColumnName) ELSE '' END) ^|^|   >> %HOME_GenStat%\scripts\GenStat.bteq
ECHO 	       MAX(CASE WHEN ColumnPosition = 18 THEN ','  ^|^| TRIM(ColumnName) ELSE '' END) ^|^|   >> %HOME_GenStat%\scripts\GenStat.bteq
ECHO 	       MAX(CASE WHEN ColumnPosition = 19 THEN ','  ^|^| TRIM(ColumnName) ELSE '' END) ^|^|   >> %HOME_GenStat%\scripts\GenStat.bteq
ECHO 	       MAX(CASE WHEN ColumnPosition = 20 THEN ','  ^|^| TRIM(ColumnName) ELSE '' END) ^|^|   >> %HOME_GenStat%\scripts\GenStat.bteq
ECHO 	       MAX(CASE WHEN ColumnPosition ^> 20 THEN ',...' ELSE '' END) )    AS ColList           >> %HOME_GenStat%\scripts\GenStat.bteq
ECHO 	FROM %1.TargetTable TT JOIN DBC.Indices IND                                                  >> %HOME_GenStat%\scripts\GenStat.bteq
ECHO 	ON TT.DatabaseName = IND.DatabaseName                                                        >> %HOME_GenStat%\scripts\GenStat.bteq
ECHO 	AND TT.TableName = IND.TableName                                                             >> %HOME_GenStat%\scripts\GenStat.bteq
ECHO 	GROUP BY IND.DatabaseName                                                                    >> %HOME_GenStat%\scripts\GenStat.bteq
ECHO 	        ,IND.TableName                                                                       >> %HOME_GenStat%\scripts\GenStat.bteq
ECHO 	       ,IndexNumber) AS DBC_Ind                                                              >> %HOME_GenStat%\scripts\GenStat.bteq
ECHO 	RIGHT JOIN %1.STATS_INFO                                                                     >> %HOME_GenStat%\scripts\GenStat.bteq
ECHO 	ON TRIM(Column_List)  = TRIM(ColList)                                                        >> %HOME_GenStat%\scripts\GenStat.bteq
ECHO.                                                                                                >> %HOME_GenStat%\scripts\GenStat.bteq
ECHO 	CROSS JOIN %1.TargetTable TT1;                                                               >> %HOME_GenStat%\scripts\GenStat.bteq
ECHO.                                                                                                >> %HOME_GenStat%\scripts\GenStat.bteq
ECHO .EXPORT RESET                                                                                   >> %HOME_GenStat%\scripts\GenStat.bteq
REM ECHO .RUN FILE %HOME_GenStat%\file\%2.txt                                                        >> %HOME_GenStat%\scripts\GenStat.bteq
ECHO.                                                                                                >> %HOME_GenStat%\scripts\GenStat.bteq
ECHO .LOGOFF;                                                                                        >> %HOME_GenStat%\scripts\GenStat.bteq
ECHO .QUIT;                                                                                          >> %HOME_GenStat%\scripts\GenStat.bteq


BTEQ < %HOME_GenStat%\scripts\GenStat.bteq > %HOME_GenStat%\log\GenStat.log
cls
ECHO *******************************************************************************************************************
ECHO ****
ECHO ****                  STEP 5: Check if Metadata tables exist - Drop and Create
ECHO ****
ECHO *******************************************************************************************************************
ECHO.                                                                             >> %HOME_GenStat%\scripts\Drop_Meta.bteq 
TYPE  %HOME_GenStat%\logon\logon.txt                                              >> %HOME_GenStat%\scripts\Drop_Meta.bteq 
ECHO.                                                                             >> %HOME_GenStat%\scripts\Drop_Meta.bteq 
ECHO SEL * FROM DBC.Tables WHERE DatabaseName = '%1' AND TableName = 'STATS_STG'; >> %HOME_GenStat%\scripts\Drop_Meta.bteq 
ECHO .if activitycount ^> 0 THEN DROP TABLE %1.STATS_STG;                         >> %HOME_GenStat%\scripts\Drop_Meta.bteq    
ECHO.                                                                             >> %HOME_GenStat%\scripts\Drop_Meta.bteq    
ECHO SEL * FROM DBC.Tables WHERE DatabaseName = '%1' AND TableName = 'STATS_INFO';>> %HOME_GenStat%\scripts\Drop_Meta.bteq 
ECHO .if activitycount ^> 0 THEN DROP TABLE %1.STATS_INFO;                        >> %HOME_GenStat%\scripts\Drop_Meta.bteq    
ECHO.                                                                             >> %HOME_GenStat%\scripts\Drop_Meta.bteq    
ECHO SEL * FROM DBC.Tables WHERE DatabaseName ='%1' AND TableName = 'TargetTable';>> %HOME_GenStat%\scripts\Drop_Meta.bteq 
ECHO .if activitycount ^> 0 THEN DROP TABLE %1.TargetTable;                       >> %HOME_GenStat%\scripts\Drop_Meta.bteq    
ECHO.                                                                             >> %HOME_GenStat%\scripts\Drop_Meta.bteq    
ECHO .LOGOFF;                                                                     >> %HOME_GenStat%\scripts\Drop_Meta.bteq    
ECHO .QUIT;                                                                       >> %HOME_GenStat%\scripts\Drop_Meta.bteq 
  
BTEQ < %HOME_GenStat%\scripts\Drop_Meta.bteq  > %HOME_GenStat%\log\Drop_Meta.log

cls
echo **********************************************************************************************************
echo.
echo. DDL creation complete...Check %HOME_GenStat%\file for DDL script files
echo.
echo **********************************************************************************************************
echo.
echo.
echo.



echo.
echo.