IBM DB2 User Manual

this if the cursor (iterator) for a positioned UPDATE or DELETE statement is in
the same package as the positioned UPDATE or DELETE statement.
v Fully qualify DB2 table names in positioned UPDATE and positioned DELETE
statements.
Related tasks
“Program preparation for SQLJ programs” on page 183
“Binding SQLJ applications to access multiple database servers” on page 185
Related reference
“sqlj - SQLJ translator” on page 392
“db2sqljcustomize - SQLJ profile customizer” on page 395
“db2sqljprint - SQLJ profile printer”
″BIND and REBIND options″ (DB2 Command Reference)
db2sqljprint - SQLJ profile printer
db2sqljprint prints the contents of the customized version of a profile as plain text.
Authorization
None
Command syntax
 db2sqljprint profilename 
Command parameters
profilename
Specifies the relative or absolute name of an SQLJ profile file. When an
SQLJ file is translated into a Java source file, information about the SQL
operations it contains is stored in SQLJ-generated resource files called
profiles. Profiles are identified by the suffix _SJProfileN (where N is an
integer) following the name of the original input file. They have a .ser
extension. Profile names can be specified with or without the .ser
extension.
Examples
db2sqljprint pgmname_SJProfile0.ser
Related concepts
Chapter 15, “Problem diagnosis with the IBM Data Server Driver for JDBC and
SQLJ,” on page 483
Related reference
“sqlj - SQLJ translator” on page 392
“db2sqljcustomize - SQLJ profile customizer” on page 395
“db2sqljbind - SQLJ profile binder” on page 407
412 Application Programming Guide and Reference for Java
™

IBM DB2 Specifications

General

Developer	IBM
Initial Release	1983
License	Proprietary
Written in	C, C++
Category	Database Management System (RDBMS)
Operating System	Linux, Windows
Programming Languages	C, C++
Data Models	Relational
Editions	Community, Standard, Advanced
Key Features	high availability, scalability