Sybase query in 1 line of code - possible?

I assume you mean a command line command??

If that's the case just put your script into a batch file and call the batch file

edit: alternatively put the SQL bit into a .sql file and pass the .sql file in as a parameter to the isql.exe

veryangryman wrote: »

Thanks but lets assume i cant use a file - the creation of the file is kinda another command.

Any other suggestions to do in 1 line

It would be helpful to describe your constraints in more detail.

do it in 2 using :

Select count(*) from SomeDB..SomeTable where Something=something
go

you could using osql on a MS-SQL server as it has a -q parameter i.e. -q "query text"

croo wrote: »

I don't know anything about Sybase but have you tried just echo-ing the db commands and pipe that through to isql? Something along the lines of ...

I'm going to have to admit the same here, but the below is derived from a solution I have used for Oracle for various things in the past. It's not technically a one liner, but it may well be the closest you're going to get:

isql -Usa -Psybase11  <<ENDOFSQL
Use someDB
go
Select count(*) from SomeTable where Something=something
go
exit
ENDOFSQL

As already noted though, the question is why do you need to do this? For one thing you're executing multiple commands in Sybase, but yet want them in one line in bash (odd, and potentially straightforward). In a more general sense though, you are presumably not looking for this for interactive use, as it would just be easier to access via the intended prompt, but yet you say it's not to be scripted - simply put, why are you trying to do this in this manner, and what are you hoping to achieve?