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
What is bind package and plan in db2?
How can you count the number of rows from a table tab?
What is the role of schema in the db2 database?
List some fields from sqlca?
Mention the way of highlighting as well as putting a cursor to use in a cobol program.
Mention the various locks that are available in db2.
Explain packages.
What is cascading rollback?
What is rct?
What is cursor with hold option in db2?
How to view db2 table structure?
Define declaration generator (dclgen).
What is coalesce in db2?
What happens in bind step in a db2 program?
What is a system catalog table in db2?