The following restrictions
apply to DB2® applications that contain SQLJ files.
- DB2 SQLJ
support adheres to standard DB2 restrictions on issuing SQL
statements.
- A positioned UPDATE and DELETE statement is not
a valid substatement in
a compound SQL statement.
- When you use a java.math.BigDecimal host
variable, the
precision and scale of the host variable is not available during the
translation
of the application. If the precision and scale of the decimal host
variable
is not obvious from the context of the statement in which it is used,
you
can specify the precision and scale by doing an explicit CAST expression.
- You cannot use a Java™ variable
with type java.math.BigInteger as
a host variable in an SQL statement.