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
- 19085 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 |
Can i insert bulk records into a db2 table using qmf of spufi only............!!!
wht steps we need will coding cobol and db2 pgm ?
i want to maintain uniqueness on pdf without make lf??????????
How do you prepare a COBOL + DB2 program from coading till execution ?
is it possible to get -811 error when you use cursors. why?
What is a DB2 bind?
quary for 1> fetch last record 2> fetch in reverse order 3> fetch last 5 row 4> fetch second last record (their is no primary key) i think concept of count can be use for this in 4th
What are data types?
I have a subprogram B calling from mainprogram A.I have opened a cursor in A ,Can i fetch the same cursor in subprogram B , If yes , Please explain the reason?
What is cursor with hold option in db2?
How to update more then one record using update?
AGGREGATE function support by DB2. A) SUM & AVG B) SUM, MIN & AVG C) SUM, MAX, AVG , MIN &COUNT D) NONE
COBOL 
