Solved

Sybase SQL Anywhere ISQL from command line

Posted on 2000-04-26
3
3,424 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
  • 2
3 Comments
 
LVL 2

Accepted Solution

by:
jkotek earned 50 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

Master Your Team's Linux and Cloud Stack!

The average business loses $13.5M per year to ineffective training (per 1,000 employees). Keep ahead of the competition and combine in-person quality with online cost and flexibility by training with Linux Academy.

Question has a verified solution.

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

Suggested Solutions

For months I had no idea how to 'discover' the IP address of the other end of a link (without asking someone who knows), and it drove me batty. Think about it. You can't use Cisco Discovery Protocol (CDP) because it's not implemented on the ASAs.…
Data breaches are on the rise, and companies are preparing by boosting their cybersecurity budgets. According to the Cybersecurity Market Report (http://www.cybersecurityventures.com/cybersecurity-market-report), worldwide spending on cybersecurity …
This Micro Tutorial will teach you how to censor certain areas of your screen. The example in this video will show a little boy's face being blurred. This will be demonstrated using Adobe Premiere Pro CS6.
Along with being a a promotional video for my three-day Annielytics Dashboard Seminor, this Micro Tutorial is an intro to Google Analytics API data.

770 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