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 bind package and plan in db2?

604


How can you count the number of rows from a table tab?

647


What is the role of schema in the db2 database?

665


List some fields from sqlca?

617


Mention the way of highlighting as well as putting a cursor to use in a cobol program.

639






Mention the various locks that are available in db2.

622


Explain packages.

670


What is cascading rollback?

629


What is rct?

761


What is cursor with hold option in db2?

622


How to view db2 table structure?

603


Define declaration generator (dclgen).

673


What is coalesce in db2?

691


What happens in bind step in a db2 program?

578


What is a system catalog table in db2?

597