HP-UX

Hi all,

I need to bring the message to log file.Teradat/Hp-Ux

script:
-----
### Update Log Table
bteq <<- EOC
.run file ${SRC_DATA}/logon.txt
.run file ${SRC_DATA}/dbstagebteq.txt
.set format off
.set foldline off all
.set sidetitles off
.set width 254
.set foldline on 1


UPDATE GCS_ETL_EXTRACT_LOG
SET Run_Date='${RUN_DATE}'
,Source_Row_count=${SOURCE_CNT}
,Actual_Row_Count=${ACTUAL_CNT}
,Extract_Status='${EXTRACT_STATUS}'
WHERE Source_System_Id='${SOURCE_SYS_ID}'
AND Source_File_Name='${SOURCE_FILE_NAME}'
AND Business_Date='${BUSINESS_DATE}'
ELSE
INSERT INTO GCS_ETL_EXTRACT_LOG
( Source_System_Id
,Source_File_Name
,Business_Date
,Run_Date
,Source_Row_Count
,Actual_Row_count
,Extract_Status)
VALUES( '${SOURCE_SYS_ID}'
,'${SOURCE_FILE_NAME}'
,'${BUSINESS_DATE}'
,'${RUN_DATE}'
,${SOURCE_CNT}
,${ACTUAL_CNT}
,'${EXTRACT_STATUS}');

.IF ERRORCODE = 0 THEN .GOTO UPDATEOK
.LOGOFF
.QUIT 08

.LABEL UPDATEOK
.LOGOFF
.QUIT 0
EOC


if [ $? -eq 0 ]
then
echo " "
echo "Update of GCS_ETL_EXTRACT_LOG table successfully completed."
echo " "
else
echo " "
echo "Update of GCS_ETL_EXTRACT_LOG table failed."
echo " "
exit 99
fi
===============================------------------------------------------------
now output displays on UX box itself,want to brind it into log file:
-------------------------------------------------------
*** Warning: EOF on INPUT stream.
+---------+---------+---------+---------+---------+---------+---------+----
.set format off
+---------+---------+---------+---------+---------+---------+---------+----
.set foldline off all
+---------+---------+---------+---------+---------+---------+---------+----
.set sidetitles off
+---------+---------+---------+---------+---------+---------+---------+----
.set width 254
+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+-
.set foldline on 1
+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+-


UPDATE DBS_GCS_ETL_EXTRACT_LOG
SET Run_Date='2007-08-22'
,Source_Row_count=85
,Actual_Row_Count=85
,Extract_Status='S'
WHERE Source_System_Id='EXE'
AND Source_File_Name='GCS.HK.XXR.dat'
AND Business_Date='2007-02-28'
ELSE
INSERT INTO DBS_GCS_ETL_EXTRACT_LOG
( Source_System_Id
,Source_File_Name
,Business_Date
,Run_Date
,Source_Row_Count
,Actual_Row_count
,Extract_Status)
VALUES( 'EXE'
,'GCS.HK.XXR.dat'
,'2007-02-28'
,'2007-08-22'
,85
,85
,'S');

*** Insert completed. One row added.
*** Total elapsed time was 1 second.


+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+-

.IF ERRORCODE = 0 THEN .GOTO UPDATEOK
.GOTO UPDATEOK
+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+-
.LOGOFF
*** Skipped.
+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+-
.QUIT 08
*** Skipped.
+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+-

.LABEL UPDATEOK
+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+-
.LOGOFF
*** You are now logged off from the DBC.
+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+-
.QUIT 0
*** Exiting BTEQ...
*** RC (return code) = 0

Update of DBS_GCS_ETL_EXTRACT_LOG table successfully completed.


thanks in advance.

How are you running the script? Just run it as:

Code:

./script_name > /path/to/logfile 2>&1