SQL client to use from batch

[miskox]

Somehow I have to work with DB2 that is hosted on IBM mainframe. I want to run SQL commands from batch that will update DB2 tables. Let's say that I have/I will have required DB2 driver on my PC (I will install SQuirrel Client with the required driver but this application does not support command line/batch use from what I read on the web. So I guess this driver will do.). I guess I have to have a SQL client on my PC... I really have so little experience with this.

I guess as small SQL client as possible would be great.

I will generate SQL statements from batch and after that I would run them.

Please advise and thanks.

Saso

[Squashman]

We got rid of DB2 on our Mainframe many years ago, but whomever is the DB admin can give the client to install.

[miskox]

I already asked one person from the development team. All I got was:"I don't know what to do."

Good idea: I will ask DB2 admin.

Saso

[shodan]

You might be able to use these free clients

https://stackoverflow.com/questions/860 ... db2-client

These

http://www.squirrelsql.org/
http://eclipsesql.sourceforge.net/index.php
http://www.oracle.com/technetwork/devel ... index.html

[miskox]

Thanks. Will check them out.

I contacted our DB2 admin to see what could be done - looks like IBM has an official Windows batch/command line option.

Saso

[Squashman]

Thanks. Will check them out.

I contacted our DB2 admin to see what could be done - looks like IBM has an official Windows batch/command line option.

Saso

Yes. It will come with the client and the odbc driver.