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.
- If you implemented security using the Kerberos authentication
protocol, you cannot use a cached Kerberos ticket-granting ticket
(TGT) to deploy an SQLJ routine. A user ID and password are required.