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.