Check if `isql` queries succeed

Question

Is there any way to check if an isql query has failed? It seems isql returns 0 whether queries succeed or not, only returning false if there was a error connecting to the server. How can I determine whether or not my Sybase queries work from the command line?

score 0 · Answer 1 · answered Feb 08 '13 at 05:34

0

Just Run this commands

 isql -v SERVERNAME Username password

At the prompt run your query

>SELECT COUNT (*) FROM table

+------+
|      |
|  100 |    
+------+

If you dont get any value back there is some problems

answered Feb 08 '13 at 05:34

Im asking if you can check that a query has failed not if *isql* has failed. – Aaron Feb 10 '13 at 22:31

score 0 · Accepted Answer · answered Feb 10 '13 at 22:44

0

--retserverror seemed to be what I was looking for.

answered Feb 10 '13 at 22:44

Aaron

199
1
6

Check if `isql` queries succeed

2 Answers2