dmiebim
asked on
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
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
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
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...
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 ?
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. :)
ASKER
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.
I've used with or without whitespace many times, no problem.
So:
isql -UuserName -Sservername -Ppassword -iinput.sql -ooutput.txt
Or:
isql -U userName -S servername -P password -i input.sql -o output.txt