In isql, is there a way for me to run several SQL statements from a file?

Question

I have a file that contains several SQL queries.

Can I somehow run them via isql (I'm doing the calls from Bash script, so no access to Perl DBI or JDBC)

I tried piping them into isql command via echo /my/file | isql -my-other-parameters but that didn't work.

score 0 · Accepted Answer · answered Jan 02 '15 at 04:10

Yes.

If you're running ISQL in interactive mode, you can load an entire contents of the file using :r my-filename command from > prompt.
From Bash script, it's also possible to do - but you need to carefully make sure that
1. The SQL file you are piping in has a go statement at the end. That is a VERY common cause of issues like the one you mentioned.
2. That statement has a newline after it.
From a script, you can do it 2 ways: Pass on STDIN via a pipe/redirect; OR, pass in the file name via isql's -i parameter

Thank you! #1 was the cause of the issue. I added a GO and it worked perfectly! — user25235, Jan 02 '15 at 04:17

score 0 · Answer 2 · answered Mar 21 '17 at 18:49

0

In my case it was isq -n for a piped query to work.

answered Mar 21 '17 at 18:49

Umair A.

score 0 · Answer 3 · edited Aug 14 '17 at 17:07

0

isql -U $DB_USR -P $DB_PWD -S $DB_PATH -D $DB_NAME -w 500 < $FILE

edited Aug 14 '17 at 17:07

rene

answered Aug 14 '17 at 15:21

SDF

While this code snippet may solve the question, [including an explanation](//meta.stackexchange.com/questions/114762/explaining-entirely-code-based-answers) really helps to improve the quality of your post. Remember that you are answering the question for readers in the future, and those people might not know the reasons for your code suggestion. Please also try not to crowd your code with explanatory comments, this reduces the readability of both the code and the explanations! – rene Aug 14 '17 at 17:07

3 Answers3