View previous topic :: View next topic
|
Author |
Message |
rohanthengal
Active User
Joined: 19 Mar 2009 Posts: 206 Location: Globe, India
|
|
|
|
Does anyone know the command to view unique constraint present on table through BMC DB2 cataog manager ? |
|
Back to top |
|
|
rohanthengal
Active User
Joined: 19 Mar 2009 Posts: 206 Location: Globe, India
|
|
|
|
actually i am getting SQLCODE = -803 while inserting row in table which does not have any primary key.. I checked primary keys for table using command '' PK. |
|
Back to top |
|
|
rohanthengal
Active User
Joined: 19 Mar 2009 Posts: 206 Location: Globe, India
|
|
|
|
Got it.. Finally after multiple trial and errors i found the command as IM.
This will show the columns on which we have UNIQUE constraints. |
|
Back to top |
|
|
|