[Last Call] Learn how to a build a cloud-first strategyRegister Now


isql command does not take input sql file in sybase iq

Posted on 2010-01-08
Medium Priority
Last Modified: 2012-05-08
Hi there,
I've Sybase IQ Server 12.7 on Suse Linux ES 10. I try to run isql command on command prompt like;
isql -UuserName -Sservername -Ppassword -i input.sql -o output.txt
but nothing returns.
I can connect the server with ;  isql -UuserName -Sservername -Ppassword
and isql prompt gets. (1> ). sql command that written in input.sql is working here.

Do you have any idea why the isql command does not take the input sql and returns nothing?


Question by:dmiebim
  • 3
  • 2
LVL 24

Accepted Solution

Joe Woodhouse earned 1000 total points
ID: 26210130
Do you have a "go" on its own as the last line of the file?
LVL 14

Expert Comment

by:Jan Franek
ID: 26210193
Try to use unified approach to spaces - all parameter with or without space between switch and parameter, but not mix of both.

isql -UuserName -Sservername -Ppassword -iinput.sql -ooutput.txt

isql -U userName -S servername -P password -i input.sql -o output.txt
LVL 24

Expert Comment

by:Joe Woodhouse
ID: 26210273
Jan - does whitespace really matter to the isql command line? I'm pretty sure that I've mixed and matched before without it giving me any trouble...
Upgrade your Question Security!

Add Premium security features to your question to ensure its privacy or anonymity. Learn more about your ability to control Question Security today.

LVL 14

Expert Comment

by:Jan Franek
ID: 26210587
I must admit, I didn't try it. I remember, that I had some problem with whitespace, I'm not sure if it was the same scenario. However, it was the first possible solution and as it's very easy to test, why not try it ?
LVL 24

Expert Comment

by:Joe Woodhouse
ID: 26210696
I know some Sybase command line tools seem to care about it (some require whitespace; some require there not be), but I'm fairly sure the humble isql doesn't care. I'd still like to hear if there was a final "go" in the script, though - that's something I've done more times than I care to admit. :)

Author Comment

ID: 26210916
You're right, Joe, problem is forgotten "go".  I know it from ASE but I couldn't foresee it in ASA.
I've used with or without whitespace many times, no problem.


Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

Question has a verified solution.

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

Last month Marc Laliberte, WatchGuard’s Senior Threat Analyst, contributed reviewed the three major email authentication anti-phishing technology standards: SPF, DKIM, and DMARC. Learn more in part 2 of the series originally posted in Cyber Defense …
Exchange administrators are always vigilant about Exchange crashes and disasters that are possible any time. It is quite essential to identify the symptoms of a possible Exchange issue and be prepared with a proper recovery plan. There are multiple…
Loops Section Overview
Look below the covers at a subform control , and the form that is inside it. Explore properties and see how easy it is to aggregate, get statistics, and synchronize results for your data. A Microsoft Access subform is used to show relevant calcul…

829 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