var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Pass variable from Sybase to shell
I know how to do this in oracle , but cant deduce the way out in sybase.
I need to pass out the variable from sybase sql anonymous block into shell , so that
I can play with the variable value in shell.
Help me out ....
Sorry, I don't understand, can you give an example?
Will give you a brief idea----
from shell I enter the sybase T-sql,
run a normal sql
based on some criteria from the sql result i populate a variable in sybase.
Now I need to pass this variable to shell so that I can perform neccesary actions.
You'll have to output the result to a file
then read the file
e.g. Here is a script that will return the last day of the month for any date passed as an argument
#export PS4='$LINENO: '
trap 'rm "$logfile"' 0
isql -Usa -P -Smysrv -b -o$logfile <<EOF
set nocount on
grep "Msg" "$logfile" >/dev/null
if [ $? -ne 1 ]
echo "Last day of the month is: $eom"
Last edited by pdreyer; 06-25-07 at