Restrictions on using REXX to program embedded SQL applications

Restrictions on embedded SQL applications created using REXX limit the type of SQL statement that you can use, and some languages are not supported.

Following are the restrictions for embedded SQL in REXX applications:

Embedded SQL support for REXX stabilized in Db2® Version 5, and no enhancements are planned for the future. For example, REXX cannot handle SQL object identifiers, such as table names, that are longer than 18 bytes. To use features introduced to Db2 database systems after Version 5, such as table names from 19 to 128 bytes long, you must write your applications in a language other than REXX.
Compound SQL is not supported in REXX/SQL.
REXX does not support static SQL.
REXX applications are not supported under Japanese or Traditional Chinese EUC environments.