Can i connect from a .sh or .sc to a database?

Shell Programming and Scripting
1

please, help me-....

i need connect to a database Sybase IQ 12 and I don't know if i can do it using a shell program.

if it's posibble, please tell me how...

please, help me, because I don't know what to do....

thanks...

jonathan

2

Just use a here document via isql... e.g.

#!/bin/sh
isql -Usa -Ppasswd <<EoF
select * from foo_table
where bar = "blah"
go
EoF
exit 0

Cheers
ZB