Hi,

I like to write a simple query, but just can't pass to sybase query


#!/bin/ksh
export key1=$1
isql -Umy_id -Smy_DB -Pmy_passwd << EOF
select * from my_table
where id like "%key1%"
go
exit
EOF


but it just does not return anything.

Hi,
Write the query in a sql file.
Then replace the variable in sql file using sed command.
Now run the sql file
isql -Umy_id -Smy_DB -Pmy_passwd -i<sql file> -o<Output file>

I figure out what the problem is....as I just "modified" from a script
i put the -o option, hence it sends to a file