Shell Programming and Scripting

#! /usr/bin/ksh

# This scripts extracts data from Sybase for the audit. A complete subscriber dump is retrived
#
# ----------------------------------------------------------------------

checkError()
{
STATUS=$1
if [[ $STATUS != 0 ]] 
then
  echo "[$STATUS] - $2"
  exit $STATUS
fi
}

function getDate
{
  print -n "`date '+%Y%m%d.%H%M%S'`"
}

. $AUDIT_MAIN_HOME/bin/audit.conf

SUBPATH=./$0
export SUBPATH=${SUBPATH%/*}

$SUBPATH/../common/outputFile_date.sh $*

checkError $? "parameter checking failed"

export OUTPUT_FILE=$1
export INPUT_DATE=$2
export INPUT_NDC=470

# replaces .sh by .sql
export SQL_SCRIPT=${0%.sh}.sql
echo SQL_SCRIPT[$SQL_SCRIPT]

. $SUBPATH/db_parameter.sh

SQL_EFFECTIVE_DATE=$INPUT_DATE

# A new temporary query is created
SQL_SCRIPT_TMP=$SQL_SCRIPT.tmp
rm -f $SQL_SCRIPT_TMP

#----------

PROGRAM=$AUDIT_MAIN_HOME/jar/buildQuery.jar
CMD="$JAVA_BIN/java -jar $PROGRAM \
-input_file $SQL_SCRIPT \
-db_area $TMP_DATABASE \
-effective_date $SQL_EFFECTIVE_DATE \
-ndc $INPUT_NDC \
-mapping_file $AUDIT_MAIN_HOME/input/hlrd/pni_hlrd_mapping.xml"
echo CMD[$CMD]
$CMD

SQL_PARAMETERS="$SQL_SCRIPT_TMP $OUTPUT_FILE $SQL_EFFECTIVE_DATE $INPUT_NDC $TMP_DATABASE"
echo "Executing SQL_PARAMETERS[$SQL_PARAMETERS]"

# ISQL
#-----
DBCONNECTION="$SYBASE_OCS/bin/isql -S$SERVER_NAME -U$USER_NAME -P$PASSWD  \
-w1000 -o$OUTPUT_FILE -A8192 -b -i$SQL_SCRIPT_TMP"

echo DBCONNECTION[$DBCONNECTION]

# Defines the start of the query
getDate | read START_TIME
export START_TIME

echo $PASSWD|$DBCONNECTION

# Defines the end of the query
getDate | read END_TIME
export END_TIME

checkError $? "Error in the dump process"

# File created?
[[ -f $OUTPUT_FILE ]]
checkError $? "not created file[$OUTPUT_FILE]"

# build file report
$SUBPATH/../common/fileDescr.sh

checkError $? "pni query failed failed"