CLPPlus restrictions

The CLPPlus interface has certain connection, command, and statement restrictions.

The CLPPlus interface can establish database connections with the following Db2® database product:
  • IBM® Db2 for IBM i
  • Db2 Express-C
The CLPPlus interface can establish database connections with the following Db2 database products but with the following restrictions:
  • Db2 Version 9.8 Fix Pack 1 or higher. You must apply Fix Pack 1 to V9.8 before connectivity is supported.
The CLPPlus interface has the following restrictions on PL/SQL support:
  • PL/SQL functions and triggers cannot be created in a partitioned database environment.
  • The NCLOB data type is not supported for use in PL/SQL statements or in PL/SQL contexts when the database is not defined as a Unicode database. In Unicode databases, the NCLOB data type is mapped to a Db2 DBCLOB data type.
  • The XMLTYPE data type is not supported.
  • TYPE declaration is not supported in a function, procedure, trigger, or anonymous block.
  • The FOR EACH STATEMENT option is not supported for PL/SQL triggers.
Table 1. CLPPlus limitations across different data servers.
CLPPlus Feature Db2 Db2 for z/OS® IBM Informix®
Variable REFCURSOR Yes No No
SERVEROUTPUT Yes No No
EXECUTE Yes No No
LIST PACKAGES Yes Yes No
SHOW ERRORS Yes No No
UPDATE/GET/RESET DB CFG Yes No No
UPDATE/GET/RESET DBM CFG Yes No No
EXPORT Yes No No
IMPORT Yes No No
LOAD Yes No No

The EDIT command is supported in the CLPPlus window mode. The command is not supported in the CLPPlus non-window mode.