The CA Ideal PDL does not support the following DB2 SQL statements and clauses.
SQL clauses used exclusively to process SQL statements dynamically. They are the USING clause and prepared statement‑name reference.
The SQL statements that serve as documentation and that support extended semantic checking by the IBM precompiler. Their functions are already performed in CA Ideal. These statements are:
DECLARE TABLE
DECLARE STATEMENT
The interactive SQL statements and most of the SQL statements that support dynamic SQL. These statements are: