?
Solved

Sybase SQL Anywhere ISQL from command line

Posted on 2000-04-26
3
Medium Priority
?
3,551 Views
Last Modified: 2012-08-14
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
Comment
Question by:vd
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
3 Comments
 
LVL 2

Accepted Solution

by:
jkotek earned 200 total points
ID: 2755010
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
 

Author Comment

by:vd
ID: 2755436
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
 
LVL 2

Expert Comment

by:jkotek
ID: 2767177
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

Will your db performance match your db growth?

In Percona’s white paper “Performance at Scale: Keeping Your Database on Its Toes,” we take a high-level approach to what you need to think about when planning for database scalability.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

While opting for any web-to-print solution, you need to discuss with your team and some of your end users and know their opinions about your decisions. In this article we list down some questions you need to ask yourself.
Whoever said that “a picture is worth one thousand words” observed a fact that can dramatically affect your marketing success. Most people tend to learn visually, so many publishers commonly acknowledge the effectiveness of visual learning by using…
This course is ideal for IT System Administrators working with VMware vSphere and its associated products in their company infrastructure. This course teaches you how to install and maintain this virtualization technology to store data, prevent vuln…
This is my first video review of Microsoft Bookings, I will be doing a part two with a bit more information, but wanted to get this out to you folks.
Suggested Courses

719 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question