SQLCODE comed across on DUN system

With finishing of the DUN system, I writed down the SQLCODE comed across on DB2. 

1.SQLCODE = -540, ERROR:  THE DEFINITION OF TABLE IBMUSER.DUNBSINF IS    

INCOMPLETE BECAUSE IT LACKS A PRIMARY INDEX OR A REQUIRED UNIQUE INDEX 

意思是说建表后一定要建立相应的primary key的index 或者是unique index,某一个columm

指定为primary key后,就自动加上了unique 限制.

Read the rest of this entry »