SQL language

The complete SQL language is available to the CICS® programmer with only minor restrictions.

For a detailed description on using the SQL language in a CICS program, see the Programming for Db2 for z/OS in Db2 for z/OS product documentation.

In a CICS program, it is possible to use:
  • Data manipulating language (DML)
  • Data description language (DDL)
  • GRANT and REVOKE statements
CICS also supports both dynamic and static SQL statements.

However, for performance and concurrency reasons, it is recommended that in general you do not issue DDL and GRANT and REVOKE statements in CICS. You should also limit dynamic SQL use.

The reason for these recommendations is that the Db2® catalog pages can be locked, with a lower concurrency level as a consequence. Also the resource consumption for these types of SQL statements is typically higher than resource consumption for static DML SQL statements.