Need to troubleshoot UNIX w / shell script and IF..THEN command
Since you guys have a lot of questions or not enough information to work with, below is your own information and so be careful as you can. The question is - (see If [$ 7 -eq "AAA"] ... then the instruction is in bold) has an output issue where I can only output / print the counter "AAA", regardless of the variable entering "BBB "or" AAA ". As a result and as an error, the program outputs / prints the "AAA" counter.
Again, in this situation I tried my best knowledge to explain it in an approachable and quick-witted way. Thank.
-----------------------------------------------------------------------
# Print the run date
echo "**********************"
echo " TALK Program "
echo " Run Date "
date
echo "**********************"
# DIRECTORIES/VARIABLES/PARAMETERS
p1=$1
p2=$2
p3=$3
p4=$4
p5=$5
p6=$6
p7=$7
p8=$8
echo "***********************************************"
echo "The parameteres are"
echo " "
echo " Param 1 (Username/Password) = "
echo " Param 2 (User account number) = "$2
echo " Param 3 (Requestor name) = "$3
echo " Param 4 (Requestor ID) = "$4
echo " Param 7 (AAA or BBB) = "$7
echo " Param 8 (TALK Data Filename) = "$8
echo "***********************************************"
AREA1=$WILLS_TOP/bin # Switch-variable points to GENEX bin dir
AREA2=$WILLS_TOP/sql # Switch-variable points to GENEX sql dir
SQL_CTL=$AREA1/WILLSTALK.ctl # Name of SQL*Load ctrl file
SQL_VALID=$AREA2/WILLSTALK.sql # Name of validation PL/SQL script
FTP_BIN=/usr/local/bin # Where ftp program is
UNIX_GET=$FTP_BIN/ftpmget.sh # Name of UNIX file get program
UNIX_PUT=$FTP_BIN/ftpmput.sh # Name of UNIX file put program
UNIX_DEL=$FTP_BIN/ftpdel.sh # Name of UNIX file delete program
TEMP=/tmp # Name of temp dir
INPUT_DIR=/oracle/inbound # For DVLP Where input file is comming from
ARCHIVE_NT_DIR=/oracle/inbound/RFS_DVLP # For DVLP Modified on 2005
OUTPUT_DIR=/oracle/outbound/ # Where output file is going to
OUTPUT_UNIX_DIR=$OUTCSF/$$OUTLOG/ # Directory of where output is
DES_NAME=${OUTPUT_UNIX_DIR}${OUT_FILE} # Where output is going to be
USERACCNUM=$p2 # User Account Number
USERNAME=$p5 # Username
PASSWORD=$p6 # Password
AAA_OR_BBB=$p7 # Either 'AAA' or default of 'BBB'
DATAFILE_NAME=$p8 # Datafile name (NT)
SERVER='172.........' # Server (NT)
LOG_DIR=$WILLS_TIP/log # Path of log dir
LOCAL_DIR=$WILLS_TIP/data # Directory where file is at (UNIX)
ARCHIVE_DIR=$WILLS_TIP/archive # Directory for archive (UNIX)
FILE_NAME="" # File name (UNIX)
FILE_TRAN_TYPE='ascii' # File transfer type
#*****************************************************************************
# MAIN PROCEDURE
#*****************************************************************************
if [ ! "$p7" ]
then
echo "At least one MS Excel Update Data File must be entered !"
echo "No files were entered."
exit 1
fi
#----------------------------------------------------------------------
# Remove all MS Excel datafile in $GENEX_TOP/data directory if exist
#----------------------------------------------------------------------
rm -f $WILLS_TIP/data/TALK*
#--------
# FTP
#--------
${UNIX_GET} $p5 $p6 $SERVER $INPUT_DIR $DATAFILE_NAME $LOCAL_DIR "" $TEMP $FILE_TRAN_TYPE
if [ $? != 0 ]
then
echo "The MS Excel Datafile(s) ftp has failed."
exit 1
fi
if [ ! -s $LOCAL_DIR/$p8 ]
then
echo "FTP command executed, but MS Excel file(s) did not get copied."
exit 2
fi
#-----------------------------------------
# SQL*Loads - New MS Excel file to load
#-----------------------------------------
for i in $LOCAL_DIR/$DATAFILE_NAME
do
SQLOAD_DAT_FILE=`echo $i | sed "s/\// /g" | awk ' { print $NF } '`
SQLOAD_LOG_FILE=$SQLOAD_DAT_FILE.log # Sqlload log file name
SQLOAD_BAD_FILE=$SQLOAD_DAT_FILE.bad # Sqlload bad file name
if [ -s $LOG_DIR/$SQLOAD_BAD_FILE ]
then
rm -f $LOG_DIR/$SQLOAD_BAD_FILE # Remove prev. bad file, if such exists
echo "Previous bad file has been successfully removed."
else
echo "No bad file was identified and removed."
echo "Resume Normal Processing."
fi
echo $i
echo "Now loading datafile: $LOCAL_DIR/$SQLOAD_DAT_FILE"
#---------------------------------------------------------------
sed "s/@USERACCNUM/$USERACCNUM/" $SQL_CTL > $TEMP/WILLSTAL.ctl # Changing '@USERACCNUM'
#---------------------------------------------------------------
sqlldr userid=${p1} control=$TEMP/WILLSTALK.ctl \
log=$LOG_DIR/$SQLOAD_LOG_FILE \
bad=$LOG_DIR/$SQLOAD_BAD_FILE \
data=$LOCAL_DIR/$SQLOAD_DAT_FILE
if test ! -s $LOG_DIR/$SQLOAD_BAD_FILE
then
tail -20 $LOG_DIR/$SQLOAD_LOG_FILE
echo "*** Done SQL*Loader Script ***"
else
echo "The SQL*Load for MS Excel Update file has FAILED due to BAD DATA."
echo "*** Exitting Script On Failure ***"
echo "*** Process is ready for NEXT LOAD! ***"
exit 1
fi
done
#----------------------------------------
# To run a PL/SQL script
#----------------------------------------
sqlplus -s $p1 @$SQL_VALID $AAA_OR_BBB
if [ $? -ne 0 ]
then
echo "The PL/SQL script for validation has FAILED."
exit 1
fi
#----------------------------------------------------------
# Now run SQL*Plus script Flat File Report After Updating
#----------------------------------------------------------
sqlplus -s $1 <<EOF
set echo off
set heading off
set space 0
set newpage 0
set pagesize 0
set feed off
set term on
SPOOL $OUTCSF/$OUTLOG/l$4.log
SELECT 'spool $OUTCSF/$APPLOUT/o$4.out' FROM dual;
SPOOL OFF
@$OUTCSF/$OUTLOG/l$4.log
Select 'Run Date: '||to_char(sysdate, 'DD-MON-YYYY') From dual;
Select '*************************************************************' From dual;
SELECT 'ERRORS Found: '||count(*)
FROM gnx_rel_date_temp
WHERE error_text IS NOT NULL;
Select '--------------- ----------- ---------------------------------' From dual;
Select 'TRX NUMBER NEW DATE ERROR TEXT' From dual;
Select '--------------- ----------- ---------------------------------' From dual;
SELECT trx_num||'|'||new_date||'|'||error_text
FROM will_rel_date_temp
WHERE error_text IS NOT NULL;
Select '*************************************************************' From dual;
#-------------
#---- AAA ----
#-------------
if [ $7 -eq "AAA" ] then
SELECT 'Total AAA Updated: '||count(*)||' records'
FROM reldatetemp
,allcustomers
WHERE trx_num = trx_no
AND error_text IS NULL
AND attr2 IS NOT NULL
AND attr2 = TO_CHAR(new_date,'YYYY/MM/DD HH24:MI:SS');
else
exit 0
fi
#---------------
#---- BBB ----
#---------------
if [ $7 -eq "BBB" ] then
SELECT 'Total BBB Updated: '||count(*)||' records'
FROM reldatetemp
,allcustomers
WHERE trx_num = trx_no
AND error_text IS NULL
AND attr1 IS NOT NULL
AND attr1 = TO_CHAR(new_date,'YYYY/MM/DD HH24:MI:SS');
else
exit 0
fi
SPOOL OFF
EOF
#----------------------------------------------
# To delete the data files on NT
#----------------------------------------------
${UNIX_DEL} $p5 $p6 $SERVER $INPUT_DIR $DATAFILE_NAME $TEMP
mv $WILLS_TIP/data/$DATAFILE_NAME $WILLS_TIP/archive/.
# All Done!
echo "*** End of program *** "
0
Val
source
to share
2 answers
Anything between sqlplus -s $ 1 <EOF and EOF is called here-doc and is meant to be consumed by sqlplus. You really cannot expect sqlplus to understand a shell script of the form "if [" $ 7 "-eq ....]".
You must do all the "ifs" outside of this document and use the results in it. Like this:
if [ "$7" -eq "AAA" ] ; then
attr="attr2"
elsif [ "$7" -eq "BBB" ] ; then
attr="attr1"
else
echo "Bogus $7 - need AAA or BBB"
fi
....
sqlplus -s $1 <<EOF
...
SELECT 'Total $7 Updated: '||count(*)||' records'
FROM reldatetemp
,allcustomers
WHERE trx_num = trx_no
AND error_text IS NULL
AND ${attr} IS NOT NULL
AND ${attr} = TO_CHAR(new_date,'YYYY/MM/DD HH24:MI:SS');
...
EOF
Pay attention to "$ {attr}" and read a decent shell scripting tutorial.
+2
source to share
How can the script continue after this code:
#-------------
#---- AAA ----
#-------------
if [ $7 -eq "AAA" ] then
SELECT 'Total AAA Updated: '||count(*)||' records'
FROM reldatetemp
,allcustomers
WHERE trx_num = trx_no
AND error_text IS NULL
AND attr2 IS NOT NULL
AND attr2 = TO_CHAR(new_date,'YYYY/MM/DD HH24:MI:SS');
else
exit 0
fi
If $ 7 = "AAA" then run select, if $ 7 is not = "AAA" exit the script .....
Best regards
K
0
source to share