What is a NULL value? What are the pros and cons of using
NULLS?
- 2 Answers
- 8782 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / s
NULL Value indicates the absence of a value. DB2 treats
NULL as an actual value and is not equal to blank, zero or
empty string.
The default value of a CHAR data type is blanks, VARCHAR is
empty string and INT,SMALLINT,FLOAT etc is 0.
NULL is not equal to any of the above.
NULLs does not satify any condition in the SQL except when
IS NULL predicate is used. Null can be used at times when
you cannot specify a value for a column, eg middle names,
not everyone has middle names.
| Is This Answer Correct ? | 9 Yes | 0 No |
What is a page?
Is it possible to alter a table – for example adding a column, when another user is accessing or updating some columns?
What is the use of value function?
What is error -818 in db2. where can you find the timestamp of the DBRM and the source code.( precompile puts the timestamp on dbrm and source code correct?)
Normalization in DB2 – first normal form, second normal form
What will the COMMIT accomplish?
What is subquery ?
What is the difference between base table and view?
What are the rules for db2 programming?
What is DCLGEN ?
how to take the back up of the DB2 table.
When is the skeleton cursor table created?
COBOL 
