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: 206
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: 206
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: 206
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 Load new table with Old unload - DB2 DB2 6
No new posts Routing command Address SDSF to other... TSO/ISPF 2
No new posts Pulling a fixed number of records fro... DB2 2
No new posts DTL - how to define key with stacked ... TSO/ISPF 3
No new posts LTJ command CA Products 4
Search our Forums:

Back to Top