DEV Community

Query Filter
Query Filter

Posted on

deply syb

!/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)