Which is Suitable 1) or 2):
1)
isql -Usa -Ppassword -Sserver_name << EF
go
select * from table
go
EF
2)
isql -Usa -Ppassword -Sserver_name << EF
go
select * from table
go
quit
EF
Here in case 1) ,we r not exiting ISQL using exit or quit command.
In this case , will the session be remained open/ resource might not be
free properly.
it is perfectly fine i.e. 2) does not give any advantage.

There is no difference - in both cases the connection will get closed
correctly.
Michael

michael.peppler@gmail.com wrote:
There is no difference - in both cases the connection will get closed
correctly.

Michael

I'll add one thing, sort of unrelated, but since I work closely with
database security, I always cringe when I see people putting the -P
option on the isql command line, especially when it's the sa password.

A better option is to put the password as the very first line of your
input, i.e.:

isql -Sserver -Usa << EF
password
select column from table
go
EF

This prevents the sa password from showing up clear-text when someone
does a 'ps' on your box while the script is running. For tiny,
millisecond-duration sql statements, is there a high risk? No. Is
this anal retentive? Maybe. Is it easy to implement? Yes. Does it
provide better security? Yes. It's all the admin's choice in the end
I suppose but being in a government shop, I have no choice but to be
anal about this stuff.
-Mike

Hi Michael,

When you say recent versions of isql are you referring to the
sybase-released versions of ISQL? We are using ASE 12.5.3 ESD1, and
the isql binary we are using is $SYBASE/CS-12_5/bin/isql, dated Mar 9
2004.

Where does this updated isql come from, and what are some of the
additional features it provides?

Thanks,
-Mike