EasyManuals Logo

IBM DB2 User Manual

IBM DB2
585 pages
To Next Page IconTo Next Page
To Next Page IconTo Next Page
To Previous Page IconTo Previous Page
To Previous Page IconTo Previous Page
Page #297 background imageLoading...
Page #297 background image
“LOBs in JDBC applications with the IBM Data Server Driver for JDBC and
SQLJ” on page 49
Related tasks
“Learning about a data source using DatabaseMetaData methods” on page 21
“Creating and modifying database objects using the Statement.executeUpdate
method” on page 24
“Updating data in tables using the PreparedStatement.executeUpdate method”
on page 25
“Learning about parameters in a PreparedStatement using ParameterMetaData
methods” on page 31
“Retrieving data from tables using the Statement.executeQuery method” on
page 32
“Retrieving data from tables using the PreparedStatement.executeQuery
method” on page 33
“Calling stored procedures in JDBC applications” on page 45
Related reference
“JDBC differences between the current IBM Data Server Driver for JDBC and
SQLJ and earlier DB2 JDBC drivers” on page 370
SQLJ statement reference information
SQLJ statements are used for transaction control and SQL statement execution.
SQLJ clause
The SQL statements in an SQLJ program are in SQLJ clauses.
Syntax
 #sql connection-declaration-clause
iterator-declaration-clause
executable-clause
; 
Usage notes
Keywords in an SQLJ clause are case sensitive, unless those keywords are part of
an SQL statement in an executable clause.
Related reference
“SQLJ connection-declaration-clause” on page 285
“SQLJ executable-clause” on page 287
“SQLJ iterator-declaration-clause” on page 285
SQLJ host-expression
A host expression is a Java variable or expression that is referenced by SQLJ
clauses in an SQLJ application program.
Chapter 7. JDBC and SQLJ reference information 281

Table of Contents

Questions and Answers:

Question and Answer IconNeed help?

Do you have a question about the IBM DB2 and is the answer not in the manual?

IBM DB2 Specifications

General IconGeneral
DeveloperIBM
Initial Release1983
LicenseProprietary
Written inC, C++
CategoryDatabase Management System (RDBMS)
Operating SystemLinux, Windows
Programming LanguagesC, C++
Data ModelsRelational
EditionsCommunity, Standard, Advanced
Key Featureshigh availability, scalability