What do you mean by NOT NULL WITH DEFAULT? When will you
use it?

Answer Posted / shankar

when we specified NOT NULL WITH DEFAULT in the query ,the
database will set the default values to that key eg. system
date ,time.

Is This Answer Correct ?    9 Yes 10 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is the role of schema in the db2 database?

653


Why cursor is used in db2?

575


What do you mean by cursor?

586


What is db2 stogroup?

675


What is the purpose of rollback and commit?

595






How many databases are there?

592


How does db2 sample database connect?

572


What is database manager in db2?

551


What do you mean by commit and rollback?

594


ther r 2 tables OTTABLE & SALTABLE, add the otamt from OTTABLE to empsal of SALTABLE if eid is matched else add the unmatched from OTTABLE to SALTABLE

1597


What is dbrm?

645


Why do we use cursor?

599


What is the role of the data page in the db2 database?

587


How to check sequence on a table in db2?

600


How to resolve deadlock issue

17977