@@ECHO OFF ECHO **************************************************************************************** ECHO * ECHO * Author : VINAY BAGARE ECHO * Date : 03/05/2007 ECHO * Description : Utility to load delimited text file into Specific Tables ECHO * Modifiction ECHO * History : ECHO * ECHO **************************************************************************************** @ECHO OFF TITLE Loading Utility for Windows NT - Amp'd Mobile Inc cls IF "%1" == "" Out.bat IF "%2" == "" Out.bat IF "%3" == "" Out.bat IF EXIST LoadSB.ml DEL LoadSB.ml IF EXIST layout.bteq DEL layout.bteq IF EXIST InsUpd.bteq DEL InsUpd.bteq ECHO ************************************************************************************ ECHO * ECHO * Step 1: Creating the Loading Script ECHO * ECHO ************************************************************************************ ECHO .logtable %1.log_%2; >> LoadSB.ml TYPE logon.txt >> LoadSB.ml ECHO. >> LoadSB.ml ECHO .BEGIN IMPORT MLOAD TABLES %1.%2; >> LoadSB.ml ECHO. >> LoadSB.ml ECHO .LAYOUT INSLAYOUT; >> LoadSB.ml ECHO. >> LoadSB.ml ECHO. CALL LayOut.bat %1 %2 ECHO. >> LoadSB.ml TYPE dbc_col.txt >> LoadSB.ml ECHO. >> LoadSB.ml ECHO .DML LABEL UpdInsDML >> LoadSB.ml ECHO DO INSERT FOR MISSING UPDATE ROWS; >> LoadSB.ml ECHO. >> LoadSB.ml ECHO. >> LoadSB.ml CALL UpdIns.bat %1 %2 TYPE Ins_Upd.TXT >> LoadSB.ml ECHO. >> LoadSB.ml ECHO .IMPORT INFILE %3 >> LoadSB.ml ECHO. >> LoadSB.ml ECHO FORMAT VARTEXT ^'^|^' >> LoadSB.ml ECHO. >> LoadSB.ml ECHO LAYOUT INSLAYOUT >> LoadSB.ml ECHO. >> LoadSB.ml ECHO APPLY UpdInsDML; >> LoadSB.ml ECHO. >> LoadSB.ml ECHO .END MLOAD; >> LoadSB.ml ECHO. >> LoadSB.ml ECHO .LOGOFF; >> LoadSB.ml ECHO. >> LoadSB.ml CLS ECHO ************************************************************************************ ECHO * ECHO * Step 2: Loading Reference Data Using Teradata MLOAD utility ECHO * ECHO ************************************************************************************ REM MLOAD < LoadSB.ml > LoadSB.log ECHO ************************************************************************************ ECHO * ECHO * clear old files ECHO * ECHO ************************************************************************************ rem IF EXIST LoadSB.ml DEL LoadSB.ml IF EXIST layout.bteq DEL layout.bteq IF EXIST InsUpd.bteq DEL InsUpd.bteq IF EXIST layout.log DEL layout.log IF EXIST InsUpd.log DEL InsUpd.log IF EXIST dbc_col.txt DEL dbc_col.txt IF EXIST Ins_Upd.txt DEL Ins_Upd.txt