DB2 and Java

DB2 for OS/390 and z/OS supports SQLJ and JDBC for Java database applications. In general, Java applications use SQLJ for static SQL, and JDBC for dynamic SQL. However, there are features of JDBC that cannot be used yet in SQLJ, because the standard for SQLJ is still maturing.

JDBC Programming

JDBC (Java database connectivity) is an API that provides a uniform SQL interface to a large selection of relational databases and a common base on which higher-level interfaces and tools can be developed.

On the server side, JDBC supports both fenced and unfenced UDFs and stored procedures in Java. Of course, on OS/390, all stored procedures are fenced to protect the environment.

On the client side, JDBC is considered to be an “equivalent” ...

Get DB2® Universal Database for OS/390® Version 7.1 Certification Guide now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.