IBM Mainframe Forum Index
 
Register
 
IBM Mainframe Forum Index Mainframe: Search Log in to check your private messages Log in
 

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: 195
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: 195
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: 195
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

 

Search our Forum:

Similar Topics
Topic Forum Replies
No new posts How to pass arguments in a ISPSTART c... CLIST & REXX 6
No new posts Can we Insert duplicates in Primary U... DB2 0
No new posts Need to read duplicate rows from tabl... DB2 3
No new posts SEPARATE UNIQUE and NON-UNIQUE in SEP... SYNCSORT 6
No new posts VSAM Alter Command - Cylinder Extent ... JCL & VSAM 3

Back to Top