#!/bin/sh
# sybase_mydb_restore $Revision$
#bcpyrght
#***************************************************************************
# $Copyright: Copyright (c) 2022 Veritas Technologies LLC. All rights reserved $
#***************************************************************************
#ecpyrght

#***************************************************************************
# Replace /usr/sybase12 below with your actual Sybase home directory 
#***************************************************************************
SYBASE=/usr/sybase12

#***************************************************************************
# Replace SYBASE12 below with your actual name of the SQL Server
#***************************************************************************
SYBSERVER=SYBASE12

#***************************************************************************
# Determine the SYBASE_ASE and SYBASE_OCS env variables for Sybase 12.x
#***************************************************************************
OCS_QUAL=
if [ -f "${SYBASE}"/SYBASE.csh ] ; then
        SYBASE_ASE=`grep "setenv SYBASE_ASE" "${SYBASE}"/SYBASE.csh | cut -f3 -d" " | sort -u | head -1`
        SYBASE_OCS=`grep "setenv SYBASE_OCS" "${SYBASE}"/SYBASE.csh | cut -f3 -d" " | sort -u | head -1`
        export SYBASE_ASE
        export SYBASE_OCS
        OCS_QUAL=/$SYBASE_OCS
elif [ -f "${SYBASE}"/SYBASE.sh ] ; then
        SYBASE_ASE=`grep "SYBASE_ASE=" "${SYBASE}"/SYBASE.sh | cut -f2 -d"=" | sort -u | head -1`
        SYBASE_OCS=`grep "SYBASE_OCS=" "${SYBASE}"/SYBASE.sh | cut -f2 -d"=" | sort -u | head -1`
        export SYBASE_ASE
        export SYBASE_OCS
        OCS_QUAL=/$SYBASE_OCS
fi

#***************************************************************************
# Replace /usr/openv/netbackup/ext/db_ext/sybase/scripts/sybase_mydb_load
# below with your actual SQL script path which contains corresponding
# LOAD commands
#***************************************************************************
LOADDB=/usr/openv/netbackup/ext/db_ext/sybase/scripts/sybase_mydb_load

echo "Started `date`"
echo ""

SYBASE=$SYBASE; export SYBASE

RETURN_STATUS=0

# NetBackup has started a restore

#***************************************************************************
# Log the isql command and input. This line may appear in NetBackup log files.
# Do NOT replace "xxxxxxxx" with a user id or password.
#***************************************************************************
echo "$SYBASE$OCS_QUAL/bin/isql -Uxxxxxxxx -Pxxxxxxxx -I$SYBASE/interfaces -S$SYBSERVER < $LOADDB"
echo ""
echo "isql input file contains:"
cat $LOADDB
echo ""

#***************************************************************************
# Replace "sa" with your Sybase server Administrator's login name.
# Replace "manager" with your Sybase server Administrator's password.
#***************************************************************************
$SYBASE$OCS_QUAL/bin/isql -Usa -Pmanager -I$SYBASE/interfaces -S$SYBSERVER < $LOADDB

RETURN_STATUS=$?

echo ""
echo "Finished `date`"

echo "exit $RETURN_STATUS"
echo ""

exit $RETURN_STATUS