SQLJ application programming - IBM DB2 9.7 for Linux, UNIX, and Windows

Example of a simple SQLJ application
A simple SQLJ application demonstrates the basic elements that JDBC applications need to include.

Connecting to a data source using SQLJ
In an SQLJ application, as in a database application in any other language, you must be connected to a data source before you can execute SQL statements.

Java packages for SQLJ support
Before you can execute SQLJ statements or invoke JDBC methods in your SQLJ program, you need to be able to access all or parts of various Java packages that contain support for those statements.

Variables in SQLJ applications
In application programs in other languages, you use host variables to pass data between the application program and the data server. In SQLJ programs, In SQLJ programs, you can use host variables or host expressions.

Indicator variables in SQLJ applications
In SQLJ programs, you can use indicator variables to pass the NULL value to or from a data server, to pass the default value for a column to the data server, or to indicate that a host variable value is unassigned.

Comments in an SQLJ application
To document your SQLJ program, you need to include comments. You can use Java comments outside of SQLJ statements and SQL or Java comments in SQLJ statements.

SQL statement execution in SQLJ applications
You execute SQL statements in a traditional SQL program to create tables, update data in tables, retrieve data from the tables, call stored procedures, or commit or roll back transactions. In an SQLJ program, you also execute these statements, within SQLJ executable clauses.

XML data in SQLJ applications
In SQLJ applications, you can store data in XML columns and retrieve data from XML columns.

SQLJ utilization of SDK for Java Version 5 function
Your SQLJ applications can use a number of functions that were introduced with the SDK for Java Version 5.

Transaction control in SQLJ applications
In SQLJ applications, as in other types of SQL applications, transaction control involves explicitly or implicitly committing and rolling back transactions, and setting the isolation level for transactions.

Handling SQL errors and warnings in SQLJ applications
SQLJ clauses throw SQLExceptions when SQL errors occur, but not when most SQL warnings occur.

Closing the connection to a data source in an SQLJ application
When you have finished with a connection to a data source, you need to close the connection to the data source. Doing so releases the data server resources and SQLJ resources for the associated ConnectionContext object immediately.