GeeCON Prague 2014*
The moose likes JDBC and the fly likes DB2 help Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


JavaRanch » Java Forums » Databases » JDBC
Bookmark "DB2 help" Watch "DB2 help" New topic
Author

DB2 help

Maria Garcia
Ranch Hand

Joined: Jul 14, 2002
Posts: 86
Hi All,
I'm planning to build a Java application with a DB2 backend. Can anybody suggest a good online tutorial or book?


SCJP 1.4
Paulo Salgado
Ranch Hand

Joined: Jan 18, 2002
Posts: 98
Hi Maria.

For product related information, the best sources I 've got so far are the product manuals themselves.
In Windows/UNIX/Linux platform, you can find good info on Application Building Guide, Application Development Guide and Developing Enterprise Java Applications.
In the Mainframe you have the Application Programming Guide and Reference for Java, which covers installation, administration and even SQLJ.
In Java with DB2 you can use two API's for processing SQL: JDBC and SQLJ. JDBC has dynamic SQL and as far as I can tell is the most used. SQLJ has static SQL (requires binding...) and you don't hear much about it.
Sun has a JDBC Learning Center web site
here.
For SQLJ reference look at the DB2 product manuals I suggested above.
Good luck.
Maria Garcia
Ranch Hand

Joined: Jul 14, 2002
Posts: 86
Thanks Paulo!
Axel Janssen
Ranch Hand

Joined: Jan 08, 2001
Posts: 2164
Here's lot of articles, tutorials, sample apps:
http://www7b.software.ibm.com/dmdd/
Paulo Salgado
Ranch Hand

Joined: Jan 18, 2002
Posts: 98
Originally posted by Maria Garcia:
Thanks Paulo!

Anytime Maria.
I forgot to add that IBM is keeping some web pages with up-to-date Java info on DB2 Here they are:

DB2 UDB V7 Java Application Development
DB2 UDB V8 Java Application Development
Some info in these pages get to the manuals after they are reviewed. You'll also find some links Java on DB2 for OS/390 from these.
Paulo
 
GeeCON Prague 2014
 
subject: DB2 help