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

How do I add a column in db2?

812


What is plan in cobol db2?

815


How to check last update on table in db2?

839


What is rebind in db2?

797


Which component is used to execute the sql statements?

867


What happens in bind step in a db2 program?

750


How do I import data from excel to db2?

850


For a db2 column that is being defined as decimal (11, 2), discuss the cobol picture clause.

890


Explain the contention situations caused by locks?

820


Can you tell me how can you find out the # of rows updated after an update statement?

904


When reorg is used?

883


How is the value function used?

859


What is package in cobol db2?

896


What is declare cursor?

852


What does db2 mean?

793