What is check constraint. Explain with example.


No Answer is Posted For this Question
Be the First to Post Answer

Post New Answer

More DB2 Interview Questions

How to check last update on table in db2?

0 Answers  


What is the role of union all and union

0 Answers  


What is a bind in db2?

0 Answers  


Bind concepts in DB2 cobol

10 Answers   IBM, TCS, TRD, Virtusa,


Is it possible to update a primary key value? If not, what is the error code given? If yes, can more than 1 primary key column be updated at a time?

8 Answers  






What is difference between *omit and *nopass?

1 Answers   IBM, TCS,


What's the difference between DB2 active log and archive log? Thanks a lot...

2 Answers   IBM,


when i am trying to update a table having 1000 rows. the program abends.how we will come to know the last successful updated row was. we are not using any commit operations

3 Answers   IBM,


What is the format (internal layout) of ?TIMESTAMP??

1 Answers  


What is a Resource Control Table(RCT)? Describe its characteristics.

3 Answers  


EXPLAIN has output with MATCHCOLS = 0. What does it mean?

2 Answers  


Suppose we are doing transaction in a table and abend happened in between. Suppose i have completed the transaction upto X rows and I want to start the transaction again where the abend happened. I don't want to do the transaction from the first record. Then what i have to do.

9 Answers   Cap Gemini,


Categories