The SQL caching feature of CA-IDMS does not cache INSERT statements. This article describes this situation and a circumvention.
In CA-IDMS, the result of the compilation of dynamic SQL statements can be cached in memory.
This saves the overhead in compiling identical SQL statements every time they are invoked.
For ODBC and JDBC based applications which make heavy use of dynamic SQL, this can result in a significant performance benefit.
This feature does not support INSERT statements.
This is documented in the "Note:" at the top of the documentation page for
Dynamic SQL Caching.
In the case of SQL against a network-defined database, if the schema is large, this can have a noticeable impact on performance.