echo off
cls
echo *******************************************************************************
echo ** 
echo **   Author     : Vinay Bagare
echo **   Purpose    : Checking Status
echo **   Parameter  : 
echo **   Assumption : 
echo **   Program    : Chk_Stat.bat
echo ** 
echo *******************************************************************************

SET HOME_GenDDL=C:\Vindoc\UTILITY\GenDDL

IF EXIST %HOME_DBCon%\log\tmp.txt del %HOME_DBCon%\log\tmp.txt
find /N "Highest return code encountered" %HOME_DBCon%\log\*.log                 >> %HOME_DBCon%\log\tmp.txt
find /n "RC (return code)" %HOME_DBCon%\log\*.log                                >> %HOME_DBCon%\log\tmp.txt

type %HOME_DBCon%\log\tmp.txt | more

ECHO.
ECHO.
ECHO ****************************************************************************
ECHO         Fix the errors (if any) in the above output. 
ECHO         Highest return code encountered should always be '0' for a 
ECHO         successful Run.
ECHO ****************************************************************************
ECHO.
ECHO.
ECHO.

rem comment the below for debugging
del %HOME_DBCon%\log\tmp.txt