DB2:Alternatives to JDBC

General discussion on the JZOS batch launcher and toolkit
Post Reply
mwilliam
Posts: 37
Joined: Mon Oct 11, 2004 3:21 pm

DB2:Alternatives to JDBC

Post by mwilliam »

Well, I’ve been pleased once I finally found out how to successfully to connect to DB2 using a type 2 connection as opposed a type 4 connection. Nice having my jobs default to same authority as assigned by z/OS instead having to cache a connecting user id & password. :D

However, I was just curious, while executing Java code, has one work with alternatives to JDBC? Not that I have anything against JDBC, but I was wondering is there a way to pre-bind your executable SQL prior to run time, similar to the way DB2 does for embedded SQL in Cobol, C, & PL/I? At least, has any one figured out how to use DB2’s SQLJ?
Top
dovetail
Site Admin
Posts: 2022
Joined: Thu Jul 29, 2004 12:12 pm

Post by dovetail »

SQLJ is supported by DB2 in Java; its the equivalent of pre-compiled, static plan support for Java. The DB2 manual "Application Programming Guide and Reference for Java" has information on using SQLJ.
Top
Post Reply

Return to “JZOS”