What if we fail to give values in columns declared as NOT
NULL ?

Answer Posted / mani

the above mentioned will happen provided there is no default
value specified at the time of defining the table.

Is This Answer Correct ?    1 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Is ibm db2 free?

578


What does a deadlock mean in DB2?

653


How is the value function used?

606


While unloading huge amount of data from table. Suddenly job failed some error. Imagine 1M data unloading, In that 90% data unloaded only 10% left, So if want to unload the rest 10% what needs to be done? Whether do i need to start from top or anything ?

1823


What is null value in db2?

567






What are the contents of a dclmgen?

630


What are db2 tables?

649


What is null indicator in db2?

606


How can you validate Sql errors during cursor operation in db2 pgms and where do you code?

1711


What is db2? Explain.

606


What is the use of predicate?

588


define clustering index.

620


What is a plan and package in db2?

625


Where can you declare a cursor in a cobol-db2 program?

605


What is the maximum number of columns in a db2 table?

727