DB2 Resources

This web page has notes on using DB2. I'm not a DB2 person and that's why I'm creating this page. For my reference and maybe it will help you.

Resources

	DB2 UDB - http://www.ibm.com/software/data/ - download a trial version. Choose DB2 UD from the pick and choose list. On next web page click on "download" in the left frame. They may have a Free developer version and a Trial Enterprise version.
	DB2 Developer Domain - http://www7b.software.ibm.com/dmdd/?np-113
	DB2 Newsgroups - http://www-3.ibm.com/cgi-bin/db2www/data/db2/udb/winos2unix/support/newsgroup.d2w/report
	DB2 User Certification - http://www7b.software.ibm.com/dmdd/library/tutorials/db2cert/db2cert_tut.html - DB2 Certification Preparation Tutorials - Take these six tutorials at your own pace and get ready to certify.

	DB2 Installation Notes
	DB2 Survival Guide - Create Databases, Tables, and SQL Script info.
	Copying Data From MS Access to DB2 - Copy data from MS Access to DB2.
	DB2 DataPropagator - Replicate data from DB2 Databases to other Databases.

Using the JDBC-ODBC bridge w/Windows

	driver: sun.jdbc.odbc.JdbcOdbcDriver
	url example: jdbc:odbc:mydatabase

Using IBM's drivers w/Windows

	driver: COM.ibm.db2.jdbc.net.DB2Driver
	url example: jdbc:db2://localhost/mydatabase
	Possible Driver location for windows: "c:\Program Files\Sqllib\cc\c2\db2java.zip"

How do you execute an external SQL script while in the "Command Center"?

If I import a SQL script that I saved while in the Script tab my machine will hang. Is there a solution?

Click on the Script Tab. Steps: Enter some SQL, Click on "Script, Save Script", now try to import the script.

Is there a GUI interface to list and edit records in a table similar to MS Access?