#!/bin/ksh
# -----------------------------------------------------------------------
# Filename:   alIncentivesCalc.ksh
# Purpose:    Run PL/SQL to calculate Incentives for Telesales
# -----------------------------------------------------------------------


if [[ -f tmp/alIncentivesCalc.run ]]; then
   echo "Another job is already running"
   exit 1
fi

touch tmp/alIncentivesCalc.run

#testing only to be deleted
chmod 777 tmp/alIncentivesCalc.run

if [ ! -d logs ]; then
   mkdir logs
fi


max_date=`sqlplus -s scott/tiger@orcl<<eof
	set serveroutput on;
	set feedback off;
	set linesize 1000;
	select max(TO_CHAR(report_period,'YYYY-MM-DD')) from al_report_gen;
	EXIT;
	eof`


last_date=`sqlplus -s scott/tiger@orcl<<eof
	set serveroutput on;
	set feedback off;
	set linesize 1000;
	select to_char(last_day(sysdate), 'YYYY-MM-DD') from dual;
	EXIT;
	eof`


if [ $max_date -eq $last_date ]; then
	(
		sqlplus - /nolog <<-EOF	
		connect $TOCONNSTR
		set echo on feed on pages 50000
		set arraysize 1000 copycommit 1000 
		call pundism_incentive_al.cleanup_all($max_date);
		exit;
		EOF
	) >logs/AL_INCENTIVES_ONE
else
	(
		sqlplus - /nolog <<-EOF	
		connect $TOCONNSTR
		set echo on feed on pages 50000
		set arraysize 1000 copycommit 1000 
		call pundism_incentive_al.cleanup_all($max_date);
		call pundism_incentive_al.calculate_incentives($max_date);
		call pundism_incentive_al.calculate_incentives_current();
		exit;
		EOF
	) >logs/AL_INCENTIVES_TWO
fi


rm -f tmp/alIncentivesCalc.run

host1>>cat t.ksh
#!/bin/ksh
unixvar=5
RETVAL=`sqlplus -s scott/tiger@dev <<EOF
whenever sqlerror exit sql.sqlcode
set verify off heading off pagesize 0 
select 'KeepThis', sysdate, sysdate-$unixvar from dual;
exit sql.sqlcode;
EOF`

echo $RETVAL
echo $RETVAL | grep KeepThis | read junk X Y
echo "X=$X"
echo "Y=$Y"


host1>>t.ksh    
KeepThis 14-AUG-07 09-AUG-07
X=14-AUG-07
Y=09-AUG-07

Connected to:
Oracle9i Enterprise Edition Release 9.2.0.8.0 - 64bit Production
With the Partitioning option
JServer Release 9.2.0.8.0 - Production

SQL> set echo on
SQL> select sysdate from dual;

SYSDATE
---------
15-AUG-07

SQL> set pagesize 0;
SQL> select sysdate from dual;
15-AUG-07

SQL> set heading off;
SQL> select sysdate from dual;
15-AUG-07

SQL>