• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 3635
  • 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 "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?
  • 2
1 Solution
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'.
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 ....  
I have found this in SQL Any Users Guide - Part 6, Chapter 39, The ISQL utility (or in index ISQL, about/command line)
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

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