Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 3603
  • Last Modified:

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=User1;PWD=pass"
-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?
0
vd
Asked:
vd
  • 2
1 Solution
 
jkotekCommented:
I think there isn't a '-d' switch in SQL Any 5 ISQL.
Use isql.exe -c "" "<sql command>", where <sql command> should be 'call User1.TestStoredProcedure'.
0
 
vdAuthor Commented:
With some modification, your answer worked!
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 ....  
0
 
jkotekCommented:
I have found this in SQL Any Users Guide - Part 6, Chapter 39, The ISQL utility (or in index ISQL, about/command line)
0

Featured Post

Become an Android App Developer

Ready to kick start your career in 2018? Learn how to build an Android app in January’s Course of the Month and open the door to new opportunities.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now