vd
asked on
Sybase SQL Anywhere ISQL from command line
I want to execute ISQL.exe from the command line to execute a
stored procedure. This is what I have:
c:\sqlany50\win32\isql.exe
-c "ENG=test;DBN=Testdb;UID=U ser1;PWD=p ass"
-d "User1.TestStoredProcedure "
This works fine until it gets to the -d parameter. What do I need to be
able to execute the SP that's in -d ? Is the -d parameter even correct?
stored procedure. This is what I have:
c:\sqlany50\win32\isql.exe
-c "ENG=test;DBN=Testdb;UID=U
-d "User1.TestStoredProcedure
This works fine until it gets to the -d parameter. What do I need to be
able to execute the SP that's in -d ? Is the -d parameter even correct?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
I have found this in SQL Any Users Guide - Part 6, Chapter 39, The ISQL utility (or in index ISQL, about/command line)
ASKER
I had to put the call User1.TestStoredProcedure
in a separate file (with extension SQL).
So, the <sql command> above became file.sql instead of the actual command.
Is this info. in the Sybase SQL Anywhere reference manuals somewhere? I could only find vague references to this method of executing SQL ....