IBM Mainframe Forum Index
 
Log In
 
IBM Mainframe Forum Index Mainframe: Search IBM Mainframe Forum: FAQ Register
 

Command UNIQUE CONSTRAINT on any table in BMC DB2 catalog


IBM Mainframe Forums -> DB2
Post new topic   Reply to topic
View previous topic :: View next topic  
Author Message
rohanthengal

Active User


Joined: 19 Mar 2009
Posts: 204
Location: Globe, India

PostPosted: Thu Aug 18, 2016 3:48 pm
Reply with quote

Does anyone know the command to view unique constraint present on table through BMC DB2 cataog manager ?
Back to top
View user's profile Send private message
rohanthengal

Active User


Joined: 19 Mar 2009
Posts: 204
Location: Globe, India

PostPosted: Thu Aug 18, 2016 3:50 pm
Reply with quote

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
View user's profile Send private message
rohanthengal

Active User


Joined: 19 Mar 2009
Posts: 204
Location: Globe, India

PostPosted: Thu Aug 18, 2016 4:15 pm
Reply with quote

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
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic View Bookmarks
All times are GMT + 6 Hours
Forum Index -> DB2

 


Similar Topics
Topic Forum Replies
No new posts Difference between VALIDPROC and CHEC... DB2 2
No new posts Discrepancy b/w SYSIBM tables and BMC... DB2 0
No new posts Issue with CR+ catalog backup job. JCL & VSAM 18
No new posts Command line placement in DB2I panels TSO/ISPF 2
No new posts A command to change LRECL of an exist... JCL & VSAM 7
Search our Forums:

Back to Top