How do you check for a null value in a db2 column?
- 2 Answers
- 11005 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / guest
You use a null indicator on the colunm and if the null
indicator = -1 then the column has a null value.
| Is This Answer Correct ? | 32 Yes | 0 No |
Answer / angoca
By querying the catalog
select nulls
from syscat.columns
where tabschema like 'XX%'
and tabname = 'YY'
and colname = 'ZZ'"
Or with the describe command
db2 describe table ZZ.YY
| Is This Answer Correct ? | 1 Yes | 1 No |
when does the SQL statement gets executed when you use cursor in the application programming ?
What is UNION,UNION ALL?
What is the function of the Data Manager?
What is bind plan?
What is dclgen in db2?
What is syscat in db2?
Update command
What is ACQUIRE/RELEASE in BIND?
what is sql abend code -801,-802?
Differentiate between cs and rr isolation levels? Where do you specify them?
What are PACKAGES ?
What is a view? Why use it?
COBOL 
