DosTips.com

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

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

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

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

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

miskox wrote: ↑

12 Jun 2024 05:41

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.