Using Java to execute static and dynamic SQL

DB2 UDB for z/OS supports SQLJ and JDBC. In general, Java applications use SQLJ for static SQL and JDBC for dynamic SQL.

By using the Java programming language you gain the following key advantages:

  • You can write an application on any Java-enabled platform and run it on any platform to which the Java Development Kit (JDK) is ported.

  • You can develop an application once and run it anywhere, which offers the following potential benefits:

    • Reduced development costs

    • Reduced maintenance costs

    • Reduced systems managements costs

    • Flexibility in supporting diverse hardware and software configurations

SQLJ support

Get Official Introduction to DB2® for z/OS®, The, 2nd Edition 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.