isql command does not take input sql file in sybase iq

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?
Thanks.

Mustafa


dmiebimAsked:
Who is Participating?
 
Joe WoodhousePrincipal ConsultantCommented:
Do you have a "go" on its own as the last line of the file?
0
 
Jan FranekCommented:
Try to use unified approach to spaces - all parameter with or without space between switch and parameter, but not mix of both.

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

Or:
isql -U userName -S servername -P password -i input.sql -o output.txt
0
 
Joe WoodhousePrincipal ConsultantCommented:
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...
0
Cloud Class® Course: CompTIA Cloud+

The CompTIA Cloud+ Basic training course will teach you about cloud concepts and models, data storage, networking, and network infrastructure.

 
Jan FranekCommented:
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 ?
0
 
Joe WoodhousePrincipal ConsultantCommented:
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. :)
0
 
dmiebimAuthor Commented:
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.


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

All Courses

From novice to tech pro — start learning today.