15 June 2010
0 How to make a field auto incremental in DB2 ?
How to make a field auto incremental in DB2?
The following query example will show you how to set the primary key field as Auto-increment field in DB2 create table WCSADM.itemlist
(
ITEMLIST_INDEX Integer GENERATED ALWAYS AS IDENTITY,
RESULTCODE VARCHAR(254),
ADDLINFO VARCHAR (254)
)
(
ITEMLIST_INDEX Integer GENERATED ALWAYS AS IDENTITY,
RESULTCODE VARCHAR(254),
ADDLINFO VARCHAR (254)
)
Subscribe to:
Post Comments (Atom)
0 comments:
Please give your valuable comments.