What is a NULL value? What are the pros and cons of using
NULLS?
- 2 Answers
- 8802 Views
- I also Faced
- E-Mail Answers
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
B37 abend during spufi?
What is check constraint in db2?
What is host variable in db2 cobol?
What is db2? Explain.
Name the lockable units in DB2?
How to retrieve rows from a db2 table in embedded sql?
Hi Everyone... Under the Logical files, when am working on multiple rec format logical file, I have joined two pf's using the multiple record format logical file concept, but when i run queried the LF only the first mentioned pf records are reflecting and I am not able to see any of the field records specified under the second pf. Kindly let me know whats the reason behind this. Below is the str of LF., R rec PFILE(LOGICAA) CUSTNO CUSTNAME BILL K CUSTNO R rec1 PFILE(LOGICAA1) CUSTNO ADD K CUSTNO .....
What is the connection string to connect to the DB2 Database ?
How do we specify index to include or not during bind process.
If anyone has IBM Certification Dumps pls forward to me & also let me know what are the Certification Codes that are available in DB2
How is the value function used?
What is db2 command?
Which component is used to execute the sql statements?
What is sqlca?
How do I copy a table in db2?
