#!/bin/sh
#showusage <server name> <machine name> <server port> <user name> <password>
#------------------------------------------------------------------------
# Name:         installTemplateXml
#
# Purpose:      This is a Bourne Shell script for installing xml files 
#               needed for the job scheduler.
#
#------------------------------------------------------------------------

if [ $# -lt 5 ]
then
    echo -----------------------------------------------
    echo 'Usage:'  
    echo '  installTemplateXml <server name> <machine name> <server port> '
    echo '                                               <user name> <password>'
    echo 'Or '
    echo '  installTemplateXml <server name> <machine name> <server port> '
    echo '                                    <user name> <password> <language>'
    echo -----------------------------------------------
    exit
fi

if [ $# -eq 5 ]
then
  lang='en'
else
  lang=$6
fi

if [ -z "$SYBASE" ]
then
    echo -----------------------------------------------
    echo 'SYBASE environment variable is NOT set.'
    echo 'Set SYBASE environment variable and try again.'
    echo -----------------------------------------------
    exit
fi
if [ -z "$SYBASE_ASE" ]
then
    echo -----------------------------------------------
    echo 'SYBASE_ASE environment variable is NOT set.'
    echo 'Set SYBASE_ASE environment variable and try again.'
    echo -----------------------------------------------
    exit
fi
 
SYBASE_JS="jobscheduler"
#tmp=`echo  $SYBASE_ASE |cut -d"E" -f2`
#SYBASE_JS=$SYBASE_JS$tmp
#echo final SYBASE_JS is: $SYBASE_JS

echo 'Installing XML files used by Sybase Job Scheduler Templates'
$SYBASE/$SYBASE_ASE/$SYBASE_JS/bin/tempimp $lang/SybBackupDbToDiskTemplate.xml $lang $1 $2 $3 $4 $5
$SYBASE/$SYBASE_ASE/$SYBASE_JS/bin/tempimp $lang/SybBackupLogToDiskTemplate.xml $lang $1 $2 $3 $4 $5
$SYBASE/$SYBASE_ASE/$SYBASE_JS/bin/tempimp $lang/SybDeleteStatsTemplate.xml $lang $1 $2 $3 $4 $5
$SYBASE/$SYBASE_ASE/$SYBASE_JS/bin/tempimp $lang/SybRebuildIndexTemplate.xml $lang $1 $2 $3 $4 $5
$SYBASE/$SYBASE_ASE/$SYBASE_JS/bin/tempimp $lang/SybRebuildTableTemplate.xml $lang $1 $2 $3 $4 $5
$SYBASE/$SYBASE_ASE/$SYBASE_JS/bin/tempimp $lang/SybReclaimIndexSpaceTemplate.xml $lang $1 $2 $3 $4 $5
$SYBASE/$SYBASE_ASE/$SYBASE_JS/bin/tempimp $lang/SybReclaimTableSpaceTemplate.xml $lang $1 $2 $3 $4 $5
$SYBASE/$SYBASE_ASE/$SYBASE_JS/bin/tempimp $lang/SybReconfLocksTemplate.xml $lang $1 $2 $3 $4 $5
$SYBASE/$SYBASE_ASE/$SYBASE_JS/bin/tempimp $lang/SybReconfMdCacheTemplate.xml $lang $1 $2 $3 $4 $5
$SYBASE/$SYBASE_ASE/$SYBASE_JS/bin/tempimp $lang/SybReconfUsrConnsTemplate.xml $lang $1 $2 $3 $4 $5
$SYBASE/$SYBASE_ASE/$SYBASE_JS/bin/tempimp $lang/SybUpdateStatsTemplate.xml $lang $1 $2 $3 $4 $5
$SYBASE/$SYBASE_ASE/$SYBASE_JS/bin/tempimp $lang/SybSvrUpdateStatsTemplate.xml $lang $1 $2 $3 $4 $5
