What do you mean by NOT NULL WITH DEFAULT? When will you
use it?
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 are the four lockable units for DB2?
What is a DB2 bind?
How to insert more than one record using insert?
What is a NULL value? What are the pros and cons of using NULLS?
What is the difference between base table and view?
What is the syntax for creating a table in the db2 database?
What is a precompiler?
What is db2 instance?
There is a 5000 EMP in company.how we find out the 5th highest getting salary employee outof 5000 employes........
what's the best lock size that you could use when you create a tablespace?
What is the specific need of Plan and..where are the tables in DB2 are physically saved
Can you use max on a char column?