isql command does not take input sql file in sybase iq

Posted on 2010-01-08
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
    LVL 24

    Accepted Solution

    Do you have a "go" on its own as the last line of the file?
    LVL 14

    Expert Comment

    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
    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...
    LVL 14

    Expert Comment

    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
    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

    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.


    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Better Security Awareness With Threat Intelligence

    See how one of the leading financial services organizations uses Recorded Future as part of a holistic threat intelligence program to promote security awareness and proactively and efficiently identify threats.

    Not sure what the best email signature size is? Are you worried about email signature image size? Follow this best practice guide.
    Basic understanding on "OO- Object Orientation" is needed for designing a logical solution to solve a problem. Basic OOAD is a prerequisite for a coder to ensure that they follow the basic design of OO. This would help developers to understand the b…
    Internet Business Fax to Email Made Easy - With eFax Corporate (, you'll receive a dedicated online fax number, which is used the same way as a typical analog fax number. You'll receive secure faxes in your email, fr…
    Illustrator's Shape Builder tool will let you combine shapes visually and interactively. This video shows the Mac version, but the tool works the same way in Windows. To follow along with this video, you can draw your own shapes or download the file…

    761 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

    Need Help in Real-Time?

    Connect with top rated Experts

    13 Experts available now in Live!

    Get 1:1 Help Now