Interested to Buy Any Domain ? << Click Here >> for more details...
What do you mean by NOT NULL WITH DEFAULT? When will you
use it?
- 3 Answers
- 18755 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 |
How is deadlock resolved?
Q4. How will you get the count of record without using COUNT verb in query?
What technique is used to retrieve data from more than one table in a single SQL statement?
why we create view.
How to resolve -805 error in DB2?
if i made sme changes in sub pgm wht r the things to be done for this ?
My cobol program(not having any sql statements) is calling another cobol program ( having sql statements), what is needed for compilation and run in jcls .
What is the maximum number of columns in a db2 table?
how to fetch multiple records without using cursor
What if we try to insert the base table through updatable view , but failed to give a column value which is defined as NOT NULL.
What are sqlcodes –803,-805, -811, -818,-904,-911,-913,-101, +100?
How do you retrieve the first 5 characters of firstname column of db2 table emp?
COBOL 
