passing parameters to isql

vmhatup · #1 (**permalink**) 06-10-08, 13:38

We have a batch program that runs several queries in a text file. This call was invoked like this:
> isql -c "uid=dba;pwd=sql;dbn=mydb" read D:\IMS\Queries\RptGen.sql

For some unknown reason, now I'm getting error:
"isql: unknown option read" and a list of all the available parameters that isql accepts.

It used to run before. Now it doesn't. How can I modify this command line so that all the parameters are correct and this line runs?

Thanks,
VM

Martijnvs · #2 (**permalink**) 06-11-08, 05:01

use the option -i<path_to_inputfile> instead:

Code:

isql -S<servername_in sql.ini> -U<username> -P<password> -D<dbname> -i<path_to_inputfile>

trvishi · #3 (**permalink**) 06-23-08, 07:46

Quote:

Originally Posted by vmhatup

We have a batch program that runs several queries in a text file. This call was invoked like this:
> isql -c "uid=dba;pwd=sql;dbn=mydb" read D:\IMS\Queries\RptGen.sql

For some unknown reason, now I'm getting error:
"isql: unknown option read" and a list of all the available parameters that isql accepts.

It used to run before. Now it doesn't. How can I modify this command line so that all the parameters are correct and this line runs?

Thanks,
VM

The syntax you posted is for Adaptive Server Anywhere. And isql is for Sybase Adaptive Server Enterprise. Two totally different products. If you still have issues, let us know which Database Server Type you are trying to access.