Results 1 to 3 of 3
  1. #1
    Join Date
    Jun 2008
    Posts
    2

    Unanswered: passing parameters to isql

    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

  2. #2
    Join Date
    Jan 2004
    Posts
    545
    Provided Answers: 4
    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>
    I'm not crazy, I'm an aeroplane!

  3. #3
    Join Date
    Sep 2003
    Location
    Switzerland
    Posts
    443
    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.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •