CA Output Management Web Viewer 12.1 - DSNT408I SQLCODE = -540 creating the database with the supplied DB2 DDL.

Document ID : KB000004683
Last Modified Date : 14/02/2018
Show Technical Document Details
Issue:

DSNT408I SQLCODE = -540 ERROR: THE DEFINITION OF TABLE WEBVIEW.ROLEOBJ IS INCOMPLETE BECAUSE IT LACKS A PRIMARY INDEX OR A REQUIRED UNIQUE INDEX.

Environment:
DB2
Resolution:

Please use the replacement DDL supplied with RO71688 DB2 DDL DOES NOT WORK WITH EXPLICIT TABLESPACES.