#!/bin/sh







########################################################################################################
# # Source borne shell env.This is required for crontab to work as bip.sh  uses environmental variables.
########################################################################################################
. /.ss.sh






#######################################################################
# ORACLE/ARBOR ENVIRONMENT VARIABLE DECLARATION
#######################################################################
ORACLE_HOME=/var/opt/oracle/product/10g; export ORACLE_HOME
PATH=$PATH:$ORACLE_HOME/bin:/bin:/usr/bin; export PATH
ARBOR_USR=$ARBORDBU; export ARBORDBU
ARBOR_DB_PASSWD=`cat $ARBORDIR/.arborpw`; export ARBOR_DB_PASSWD
ORACLE_SID=$DSQUERY; export ORACLE_SID





#######################################################################
####MAIN SCRIPT
#######################################################################
today=`date "+%m-%d-%Y  %H:%M:%S"`; export today
CUR_DIR=/arbor/prdqa_ac/scripts ; export CUR_DIR
SCRIPT_DIR=/arbor/integ_fx/scripts
LOG_FILE=$CUR_DIR/error.log; export LOG_FILE

# Direct script output to log


echo "SQLPLUS CONNECTION"

sqlplus -s $ARBOR_USR/$ARBOR_DB_PASSWD@$ORACLE_SID<<EOF>$CUR_DIR/sql_output.txt
set feedback off
set heading off
select distinct account_no from adj  WHERE ADJ_TRANS_CODE=-2401  and request_status=1  and bill_ref_no=0
order by account_no;
EOF






if [  ! -s  "$CUR_DIR/sql_output.txt" ]
then
echo "No account number for bad debt"
else
for i in `cat $CUR_DIR/sql_output.txt`
do
echo "bip $i is running"
sh  $SCRIPT_DIR/bip.sh 01 0 $i >  $CUR_DIR/bip_log_1.txt
sleep 200
done
fi


###Removing temporary log files generated

if [ -f  "$CUR_DIR/bip_log_1.txt" ]
then
 rm  "$CUR_DIR/bip_log_1.txt"
 echo "file bip__log_1.txt removed"
fi

if [ -f "$CUR_DIR/sql_output.txt" ]
then
 rm  "$CUR_DIR/sql_output.txt"
 echo "sql_output.txt removed"
fi

rm  $CUR_DIR/error.log

ld.so.1: BIP: fatal: librc.so: open failed: No such file or directory

This occurs if the environment variable LD_LIBRARY_PATH (Sun), is not set correctly. The value should be $COBDIR/lib:$LD_LIBRARY_PATH\ 
(or the appropriate variant) on Server Express $COBDIR/coblib:$LD_LIBRARY_PATH (or the appropriate variant) on Object COBOL Developer Suite.