What do you mean by NOT NULL WITH DEFAULT? When will you
use it?
- 3 Answers
- 18093 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / s
NOT NULL WITH DEFAULT indicates that the column cannot
contain a NULL, if a user doesnt enter a value, DB2
generates the default.
| Is This Answer Correct ? | 20 Yes | 1 No |
Answer / kumar
Using 'NOT NULL WITH DEFAULT' you can also specify you own
values. INTEGER, SMALLINT will assigned with zero, CHAR,
VARCHAR will be assigned with spaces. DATE, TIME, TIMESTAMP
will be assigned with system DATE, TIME & TIMESTAMPE values
respectively.
As the table is declared with 'NOT NULL WITH DEFAULT',
there is no chance of getting the null values during data
fetch.
| Is This Answer Correct ? | 15 Yes | 2 No |
Answer / 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 |
What is deadlock in db2?
if suppose i am having an ACCOUNT table with 3 coloumns ACC. NO,ACC. NAME,ACC. AMOUNT . If a unique index is also defined on ACC.NO and ACC.NAME then write a query to retrieve account holders records who have more than 1 ACC.
wht are the restrictions for union ?
How is a typical db2 batch pgm executed?
SQLCODE = -199, ERROR: ILLEGAL USE OF KEYWORD CHAR, TOKEN KEY was expected
what is the steps followed in EXPLAIN Process or EXPLAIN command. (Explain is for identifying the optimized access path but how or what is the steps for doing the EXPLAIN)
What is the difference between TYPE 1 index & TYPE 2 index
i have cobol+ db2 program but it contains n number of subprograms for this how many dbrm members i need to mention in bind process
What is a Foreign Key?
0 Answers Tavant Technologies, Zensar,
How can you display the current date & current time ?
How is a typical DB2 batch program executed ?
how can i pull up a query which was previously stored in qmf
COBOL 
