How do you check for a null value in a db2 column?
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 |
What is phantom read in db2?
PLAN IS EXECUTABLE AND PACKAGE IS NOT EXECUTABLE . THEN WHAT IS THE USE OF PACKAGE?
2 Answers Tech Mahindra, Wipro,
What is null indicator in db2?
What is copy book?
What is a buffer in memory?
How connect db2 database to datastage?
How do I start db2 in windows?
What is an instance database?
What is an alias and how does it differ from a synonym?
where can we use index and subscript ? with example ?
can any one give the list of some important sql abend codes which r frequently asked in interviews?
Comment whether the cursor is closed during commit or not.