DB2 SQL Explorer
This is pretty easy to set up.
http://www.sqlexplorer.org/screenshots.php
SQL Explorer is great. Go look at the screen shots. It's working really well so far for me. You have to have the DB2 universal driver and set up the jar files and driver name, but that's all. Then connect to your DB, create a project, save your SQL file and start cranking!
Be careful of your transactions! (I always begin tran/rollback tran/commit train it's a good habit)
http://www.sqlexplorer.org/screenshots.php
SQL Explorer is great. Go look at the screen shots. It's working really well so far for me. You have to have the DB2 universal driver and set up the jar files and driver name, but that's all. Then connect to your DB, create a project, save your SQL file and start cranking!
Be careful of your transactions! (I always begin tran/rollback tran/commit train it's a good habit)
Follow up
I have since found that data tools for Eclipse is just as good if not better. It will allow you to load, unload data from a table. Pretty handy. See also my SO question about loading data into db2 from eclipse.
Comments
Post a Comment