Shell Programming and Scripting

#!/bin/sh

#SERVER_TYPE=$1     # rep or sql

SYBASE_VER=`ls -1 $SYBASE | grep ASE- | cut -d"/" -f1`
SYBOCS_VER=`ls -1 $SYBASE | grep OCS- | cut -d"/" -f1`
SYB_OCS=$SYBASE/$SYBOCS_VER
SYB_ASE=$SYBASE/$SYBASE_VER

SYBASE_ASE=$SYBASE_VER; export SYBASE_ASE
SYBASE_OCS=$SYBOCS_VER; export SYBASE_OCS
ISQL_CMD=$SYBASE/$SYBASE_OCS/bin/isql

COMMAND_TO_RUN=<<PUT YOUR QUERY HERE>>
DATABASE=$3
SERVER=$4

if [ "$DATABASE" != "" ]; then    # database name provided, use it
        DATABASE="use $DATABASE"
fi

if [ "$SERVER" = "" ]; then    # server not provided, use DSQUERY
        SERVER=$DSQUERY
else
        SERVER=`echo $SERVER | tr '[a-z]' '[A-Z]'`   # server provided, translate to uppercase
fi

## get the password for the server
PW=`/sybase_sa/bin/get_pw $SERVER`

## run the command
$ISQL_CMD -S$SERVER -Usa -w1000 <<EOF
$PW
set nocount on
go
$DATABASE
go
select @@servername, db_name(), convert(varchar,getdate(),109)
go
print ''
go
set nocount off
go
$COMMAND_TO_RUN
go
EOF

exit