News
Abstract
Implicit parameter marker conversion on some data-change-table-references
Content
You are in: IBM i Technology Updates > Db2 for i - Technology Updates > Db2 for i Performance Enhancements > Implicit parameter marker conversion on some data-change-table-references
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.
[{"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Product":{"code":"SWG60","label":"IBM i"},"Component":"","Platform":[{"code":"PF012","label":"IBM i"}],"Version":"All Versions","Edition":"","Line of Business":{"code":"LOB57","label":"Power"}}]
Was this topic helpful?
Document Information
Modified date:
21 January 2020
UID
ibm11116585
