Shell Programming and Scripting

#!/usr/bin/ksh
###################################################################################
SetupEnvironment () {
  ConnectionParameter="dataload/dataload@dadb"
}
###################################################################################
GetWorkingTableName() {
 sqlplus -silent /nolog @getAcxTableName.sql $ConnectionParameter 1.tmp >/dev/null
 status=$?
 if [[ $status -ne 0 ]]
 then
   print "Error from sql script getAcxTableName.sql"
   exit 1
 fi
 grep ACX 1.tmp | read tempval
 print "$tempval"
}
###################################################################################
Truncate_Table () {
  sqlplus $ConnectionParameter <<!
whenever sqlerror exit failure
set serveroutput on size 1000000
exec p_truncate("$1","$2");
exit;
!
  print "Error from sql"
}
###################################################################################
RunTheETLJob () {
 print "dummy"
}
###################################################################################
SwitchSynonym () {
 CREATE OR REPLACE PUBLIC SYNONYM ACXIOM_PROSPECT FOR $WorkTableName
 print "dummy"
}

################ M A I N   P R O G R A M ##########################################
SetupEnvironment

GetWorkingTableName|read WorkTableName
print "Tablename is $WorkTableName"
#exit 0
Truncate_Table $WorkTableName
export USER_VAR_0=$WorkTableName
print "Truncating table $WorkTableName"
RunTheETLJob
SwitchSynonym $WorkTableName
print "Switched synonym to $WorkTableName
exit 0;

whenever sqlerror exit failure
set feed off
set echo off
set pages 0
set trimspool on
connect &1
spool &2
select decode(table_name,'ACXIOM_PROSPECT_B','ACXIOM_PROSPECT_A','ACXIOM_PROSPECT_A','ACXIOM_PROSPECT_B','')
from all_synonyms where SYNONYM_NAME='ACXIOM_PROSPECT'
/
spool off;
exit;