isql from batch file

[TheJFM]

The following isql runs fine from the command line

isql -Snnnnnn -Unnnnnn -Pnnnnn -Dnnnnn -innn.sql -onnnn.txt

If I want to call it as part of a batch file how would I go about it?

Thanks in advance

 

[JeanNiBee]

Hi

Can you give more details as to what you mean "call it from a batch file?"

I'll make a simple assumption in that you may want to run queries 'through' that connection.

Try this..
-Use the -i and -o options to specify input and output files for your queries.

-You can also use Unix redirection methods of 'piping' commands into 'isql' to be executed.

ex: isql -Uuser -Ppass -Sserver < createTable.sql > results.txt

This will run the createTable script and output any results to the results.txt file.

- You can also use the "perl style" standard input to tell isql to take info from the command line and pipe the rsults to a file.

ex: isql -Uuser -Ppass -Sserver <<EOF > results.txt
(Then on command line type: select * from blah <enter>)

This will start the isql shell in the backgound and take any input typed in as sql commands. It executes the command and redirects them to results.txt

Now I can only hope this is what you needed to know.

 

[TheJFM]

Thanks

I am running it through a windows environment.

I want to schedule a series of isql from a file called nnnn.bat.

I pasted the isql that ran successfully from the command line but this did not work and returned the following error to the output file

'tbl_nnnnnnnn not found. Specify owner.objectname or use sp_help to check whether
the object exists (sp_help may produce lots of output).'

 

[JeanNiBee]

Hi

Ah, you 'may' have to specify DATABASE_NAME.dbo.table_nnnnnn as the name of the table.

These commands DO run if you are 'inside' isql though? If so, paste the code and I'll see what I can figure out from tt.

In addition I beleive you can use the < and > redirection operators in windows as well as in unix.

 

[TheJFM]

Thanks ever so much

The full table name in the sql input file worked fine

I can now sleep this weekend ;-)

 

[JeanNiBee]

Glad I could help.

As a side note your problem 'may' be because you didn't setup a defaultDB in your profile. So when you connect through the batch it's not sure WHICH db the table is in.

You can fix this like so.

sp_modifylogin your_login_name, &quot;Defdb&quot;, table_to_be_default