!/bin/bash
Define SYBASE environment variables
export SYBASE=/optware/sybase/sdk15-R
export SYBASE_OCS=OCS-15_0
export LD_LIBRARY_PATH=$SYBASE/$SYBASE_OCS/lib:$LD_LIBRARY_PATH
Define connection details and file paths
USERNAME=zeusprod
PASSWORD=zeusprod
SERVER=Comet_US_FUT_Q35_QA
DATABASE=Comet_US_Futures
INPUT_FILE=/tmp/12345.db_trade.sql
OUTPUT_FILE=/tmp/uDeploy_isql_output.log
TIMESTAMP=$(date +%Y%m%d_%H%M%S)
Log start of execution
echo "Starting uDeploy ISQL connection test at $TIMESTAMP" >> $OUTPUT_FILE
Execute isql with encryption and proof query
$SYBASE/$SYBASE_OCS/bin/isql -X -U$USERNAME -P$PASSWORD -S$SERVER -D$DATABASE -i$INPUT_FILE >> $OUTPUT_FILE 2>&1
Append proof query if input file exists
if [ -f "$INPUT_FILE" ]; then
echo "Executing proof query..." >> $OUTPUT_FILE
$SYBASE/$SYBASE_OCS/bin/isql -X -U$USERNAME -P$PASSWORD -S$SERVER -D$DATABASE << EOF >> $OUTPUT_FILE 2>&1
SELECT @@version AS server_version, getdate() AS current_date;
GO
EOF
else
echo "Input file $INPUT_FILE not found. Skipping proof query." >> $OUTPUT_FILE
fi
Check exit status
EXIT_CODE=$?
if [ $EXIT_CODE -eq 0 ]; then
echo "ISQL command executed successfully. Output saved to $OUTPUT_FILE" >> $OUTPUT_FILE
else
echo "ISQL command failed with exit code $EXIT_CODE. Check $OUTPUT_FILE for details." >> $OUTPUT_FILE
fi
Top comments (0)