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

Give the name of some fields form sqlca.

826


What is the maximum No of rows per page?

819


What is view db2?

846


How to execute stored procedures?

854


What is the use of value function?

847


How to create backup table in db2?

854


What are the two types of logging in the db2 database? Explain them.

802


What is the connection string to connect to the DB2 Database ?

865


What db2 400?

906


What is a db2 collection?

803


What is difference between alias and synonym in db2?

859


How does cobol compile db2 program?

814


Suppose pgm A calling Pgm B .Pgm B has some Db2 program. at the time of compilation should plan and package will be created for both A and B or only B? What is the concept?

7454


In an sql table that is embedded, what is the procedure to retrieve rows that are part of a db2 table?

856


Is the primary key a clustered index?

839