Embedded Structured Query language in Java (SQLJ) support
Structured Query Language in Java (SQLJ) is a set of programming
extensions that allow a programmer, using the Java programming language,
to embed statements that provide SQL (Structured Query Language) database
requests.
Advantages of developing applications with SQLJ include improved performance
and a shorter, more efficient development cycle:
- You improve performance by using static SQL statements.
- You reduce the development cycle because:
- You write less code with the simpler SQLJ syntax, which reduces the number
of lines of code required to execute statements, and to set and retrieve
parameters.
- You detect programming errors earlier in the development
phase with the onlinecheck function, which performs data type and schema
validation. You activate this function by running it as an option with the db2sqljcustomize command.
See the DB2 documentation for a complete description of the SQLJ customize
command.
You might consider using SQLJ in situations where dynamic SQL is not needed,
and where applications use DB2 as the backend database.

Using embedded Structured Query Language in Java (SQLJ) support
Using embedded Structured Query Language in Java (SQLJ) with the DB2 for z/OS Legacy driver
Using embedded Structured Query Language in Java (SQLJ) to develop applications for WebSphere Application Server for z/OS v5.0 using the DB2
Universal driver
Searchable topic ID:
sqljdef
Last updated: Jun 21, 2007 9:56:50 PM CDT
WebSphere Application Server for z/OS, Version 5.0.2
http://publib.boulder.ibm.com/infocenter/wasinfo/index.jsp?topic=/com.ibm.websphere.zseries.doc/info/zseries/ae/cdat_sqljdef.html