News
Abstract
QSYS2.RESTART_IDENTITY procedure
Content
You are in: IBM i Technology Updates > Db2 for i - Technology Updates > Db2 for i Database Engineer (DBE) Enhancements > QSYS2.RESTART_IDENTITY procedure
RESTART_IDENTITY
-
Identity value columns are guaranteed to contain a unique value.
-
When tables are copied with INCLUDING IDENTITY COLUMN ATTRIBUTES or via CL commands like Copy File (CPYF), the next value for the identity column is the defined first value
-
In many cases, the Database Engineer (DBE) would prefer to have the new table use the same “next value” as the source table.
-
Now, you can easily re-establish the identity value using the QSYS2.RESTART_IDENTITY procedure. The procedure calculates the NEXT VALUE of the source file’s identity value and alters the target file to match.
See the IBM Documentation for details: RESTART_IDENTITY procedure
[{"Business Unit":{"code":"BU070","label":"IBM Infrastructure"},"Product":{"code":"SWG60","label":"IBM i"},"Component":"","Platform":[{"code":"PF012","label":"IBM i"}],"Version":"All Versions","Edition":"","Line of Business":{"code":"LOB68","label":"Power HW"}}]
Was this topic helpful?
Document Information
Modified date:
25 March 2025
UID
ibm11168450