What is a NULL value? What are the pros and cons of using
NULLS?
Answer Posted / 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 |
Post New Answer View All Answers
What is the maximum size of varchar data type in db2?
When a COBOL-DB2 program in PRODUCTION is updating main tables and gone for long run, what have to do?
Is the primary key a clustered index?
Mention the location where the output received from explain statement is stored.
How can we retrieve the total number of records in RPG & CLLE?
What is a storage group (stogroup)?
What is db2 look?
What is the difference between plan and package in db2?
How to retrieve rows from a db2 table in embedded sql?
can any one provide me the link for the db2 v7 & db2 v8 manual for Z/os? i need to know about the syntax of REORG in both versions & need to know the difference as well
What is bind in db2?
Is db2 a database?
How do we specify index to include or not during bind process.
What is innodb buffer pool?
List some fields from sqlca?