IBM i DB2 SQL – quick tips

Page reserved for quick tips on how to do things on IBM i DB2 via SQL

Change a table’s identity column starting value

ALTER TABLE LIB.MYTABLE
ALTER COLUMN MYIDENTITYCOLUMN
RESTART WITH 100