News
Abstract
UPDATE and DELETE (SQL) statements can be embedded in a query to allow easy access to data modification detail.
Content
You are in: IBM i Technology Updates > Db2 for i - Technology Updates > Db2 for i Functional Enhancements > UPDATE and DELETE (SQL) statements supported as data-change table reference
SQL support for Data Manipulation Language (DML) is enhanced with IBM i 7.6 to support Data Change Table Reference:
- For UPDATE: OLD TABLE, NEW TABLE, and FINAL TABLE
- For DELETE: OLD TABLE
Note: INSERT already has support for Data Change Table Reference.
See the SQL Reference for details:
table-reference
DELETE
UPDATE
[{"Type":"MASTER","Line of Business":{"code":"LOB68","label":"Power HW"},"Business Unit":{"code":"BU070","label":"IBM Infrastructure"},"Product":{"code":"SWG60","label":"IBM i"},"ARM Category":[{"code":"a8m0z0000000CHeAAM","label":"IBM i Db2"}],"ARM Case Number":"","Platform":[{"code":"PF012","label":"IBM i"}],"Version":"7.6.0;and future releases"}]
Was this topic helpful?
Document Information
More support for:
IBM i
Component:
IBM i Db2
Software version:
7.6.0 and future releases
Operating system(s):
IBM i
Document number:
7229557
Modified date:
08 April 2025
UID
ibm17229557
Manage My Notification Subscriptions