# Set OpenWindows related environment variables
umask 002
setenv ORACLE_HOME /net/critter-ora.central/orahome/product/oracle
setenv TNS_ADMIN /home/so143457/oracle
setenv OPENWINHOME /usr/openwin
#setenv LD_LIBRARY_PATH $OPENWINHOME/lib:/usr/lib:/usr/dt/lib
setenv LD_LIBRARY_PATH
/net/critter-ora.central/orahome/product/oracle/lib
setenv MANPATH $OPENWINHOME/man:/usr/man:/usr/dt/man
#
#        --------------------------------------------------------------
##       NOTE:  If you need additional paths, please add them to the
##              "set lpath=(  )" line below -- between the "(  )".
#        --------------------------------------------------------------
#
set lpath=( /usr/dt/bin /usr/ucb /usr/etc ~ )
#
#        --------------------------------------------------------------
##       NOTE:  If you really need explicit priority paths, add them to
##             /home/so143457/sunStream_v1.0/posLoad  the "set fpath=( 
)" line below -- between the "(  )".
#        --------------------------------------------------------------
#
set fpath=( $OPENWINHOME/bin )
#
#        --------------------------------------------------------------
##       NOTE:  Please DO NOT MODIFY the "set path=" line below, unless
##              you are SURE you need to and sure you know how.
#        --------------------------------------------------------------
#
set path=(~/bin $fpath ~/.dist /usr/bin /usr/sbin /usr/ccs/bin
/usr/dist/exe \
          /usr/dist/local/exe /usr/local /usr/local/bin $lpath \
/net/critter-ora.central/orahome/product/oracle/bin \
/usr/dist/share/forte_dev,v6.2/SUNWspro/bin \
/usr/dist/share/devpro,v4.2/5.x-sparc/bin)
#
if ( $?prompt ) then
   set history=32
endif

setenv LPDEST whistler
setenv UTILS /home/so143457/utils
setenv EMEAHOME /home/so143457/sunStream_v1.0/common/sql
setenv OUTDBHOME /home/so143457/outDb_v1.0/sql
setenv ASSIGNHOME /home/so143457/assignTool_v1.0/sql
setenv ACTSLOAD /home/so143457/sunStream_v1.0/acts
setenv POSLOAD /home/so143457/sunStream_v1.0/posLoad
set prompt="$user@`hostname`::$cwd> "
setenv EDITOR vi
stty erase ^H
setenv SYBASE /usr/dist/pkgs/sybase/5.x
#

# JAVA
setenv JAVA_HOME /usr/dist/share/java,v1.2.2_05a/5.x-sun4
setenv CLASSPATH .
setenv PATH ${JAVA_HOME}/bin:${PATH}

#setenv EXINIT 'set ws redraw sh=/bin/csh wm=5 report=2'
set filec
set history=32
set noclobber
alias a alias
alias h history
alias rm rm -i
alias mv mv -i
alias wyse 'setenv TERM tvi925; unsetenv TERMCAP'
alias sq1 sqlplus ssemea@critdev0
alias goemeahome cd $EMEAHOME
alias gooutdbhome cd $OUTDBHOME
alias goatoolhome cd $ASSIGNHOME
alias goactsload cd $ACTSLOAD
alias goposload cd $POSLOAD
a l 'ls -lA'
alias ls 'ls -aF'
alias cls clear
alias crit-test telnet critter-test.central
a crit-dev telnet critter-dev.central
a finsys telnet finsys-ss.holland
a ituat telnet ituatcon01.singapore
a itprd telnet itprdcon02.singapore
a century telnet century.central
a cd 'chdir \!*;set prompt="$user@`hostname`::$cwd> "'
a mymozilla "mozilla ,v1.2.1beta&"
#
#
limit coredumpsize 0m

 #!/bin/csh -f
########################################################################
# Source       : valid_pos_tran_load.csh
# Author       : Sachchida Nand
# Date Created : 7th Feb 2003
#
# Modification History :
# Date    Modified By       Description (with bug ID, if any)
# 4/10/03 Sachchida nand    Expose Batch Id in the email notification
########################################################################
setenv OUTDBENV ${HOME}/OUTDB_PROD

source $OUTDBENV/scripts/set_outdb_env.csh

set PROC_DESC = "SunStream: PoS Data Transfer to OutDb"

set VARFILE = $OUTDBENV/log/outDb_load_detail.`date ' %Y%m%d%H%M'`.log
set VARLOG =  $OUTDBENV/log/outDb_load_log.`date ' %Y%m%d%H%M'`.log

sqlplus -s $VALID_ORA_USER/$VALID_ORA_PWD@$VALID_ORA_SID <<EOF >>&
$VARFILE

whenever sqlerror exit failure
set term on
set serveroutput on size 1000000
prompt SQLPLUS :: Starting ${PROC_DESC}

VARIABLE ret_val NUMBER ;
VARIABLE ret_msg VARCHAR2(1000) ;

exec valid_pos_outdb_sp;
print ret_val
print ret_msg
prompt SQLPLUS :: Valid pos outdb transfer Completed!
exit
EOF
set RETURN_STATUS = $status

echo $PROC_DESC " completed on " `date` >> $VARFILE

if ($RETURN_STATUS != 0 ) then
echo "ERROR $PROC_DESC: "  >> $VARLOG
echo "ERROR  ($PROC_DESC) Logging error in : " $VARLOG >> $VARLOG
mailx -s "$PROC_DESC Failed." $EMAILADDR < $VARFILE
exit -1
endif
echo "SUCCESS: $PROC_DESC " >> $VARFILE
echo
"********************************************************************************">>$VARLOG
echo "$PROC_DESC SuccessFul.">>$VARLOG
echo "Check File: $VARFILE" >>$VARLOG
echo
"--------------------------------------------------------------------------------">>$VARLOG
echo "                  PoS Data Transfer to OutDb Summary                           
">>$VARLOG
echo
"--------------------------------------------------------------------------------">>$VARLOG
grep Batch $VARFILE>>$VARLOG
echo
"--------------------------------------------------------------------------------">>$VARLOG
set ROWS_TRANSFERRED="`grep Batch $VARFILE |wc -l`"
if ($ROWS_TRANSFERRED != 0 )  then
mailx -s "$PROC_DESC SuccessFul." $EMAILADDR < $VARLOG
endif
exit 0

#!/bin/csh -xf

# This script is used to set environment variables
# to run programs in sunstream. Optionally this script can
# accept the module name as a parameter.
#
# Philip 4/14/00

# Notes:
#
# $SSPROD must be set correctly before invoking this script.

#
# Set path and other env variables.
#

# PLEASE SET THE FOLLOWING FOR THE DEPLOYMENT ENVIRONMENT.

setenv SYBASE /usr/dist/share/sybase/5.x
setenv DEVPRO /usr/dist/share/devpro,v4.2/5.x-sparc
setenv ORACLE_HOME /orahome/home
setenv TNS_ADMIN /home/jetstream/oracle/network
setenv OPENWINHOME /usr/openwin

set lpath=( /usr/bin /usr/sbin /usr/etc /usr/ccs/bin \
   /usr/ucb \
   /usr/dt/bin \
   /usr/dist/exe )
  
# Note: These path needs to uncommented at the time of deployment

set fpath=( $ORACLE_HOME/bin $SSPROD/bin )
set path=( . $fpath $lpath )
setenv LD_LIBRARY_PATH 
$ORACLE_HOME/lib:$OPENWINHOME/lib:/usr/lib:/usr/dt/lib:$DEVPRO/SC4.2/lib

#
# Set env variables based on values defined in parameter file
#

setenv VALID_PARAM_FILE ${HOME}/OUTDB_PROD/valid_parameters.dat

set VALID_ORA_USER="`grep sunstream.oracle.login.sunstream
$VALID_PARAM_FILE | grep -v '^#' | cut -d'=' -f2`"

set VALID_ORA_PWD="`grep sunstream.oracle.password.sunstream
$VALID_PARAM_FILE | grep -v '^#' | cut -d'=' -f2`"

set VALID_ORA_SID="`grep sunstream.oracle.server $VALID_PARAM_FILE |
grep -v '^#' | cut -d'=' -f2`"

set EMAILADDR="`grep sunstream.emailaddr.support $VALID_PARAM_FILE |
grep -v '^#' | cut -d'=' -f2`"