Restrictions on SQLJ (DB2 Universal Database)

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 sub-statement 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.

 

Parent topic

Developing SQLJ applications

 

Related tasks

Customizing and binding SQLJ profiles (DB2 Universal Database)