News
Abstract
Implicit parameter marker conversion on some data-change-table-references
Content
The original implementation of data-change-table-reference (aka Select from Insert) did not allow any statement reuse of dynamic statements when only literal values changed (also referred to as parameter marker conversion).
With this enhancement, if the insert is a simple one row VALUES clause containing only literals it will be considered eligible for reuse.
There can be no expressions, no special registers, no parameter markers, and no DEFAULT keywords in the VALUES list.
By allowing these statements to become eligible for parameter marker conversion, the statements can be reused.
Was this topic helpful?
Document Information
Modified date:
21 January 2020
UID
ibm11116585