Interested to Buy Any Domain ? << Click Here >> for more details...
How do you check for a null value in a db2 column?
- 2 Answers
- 11777 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 |
What is a DB2 plan?
What is consistency token in db2?
What is the syntax for creating a table in the db2 database?
How does coalesce work?
What technique is used to retrieve data from more than one table in a single SQL statement?
How could one combine a set of incremental image copies into a single copy?
How does one remove entries from the SCT02 table?
What are the various locking levels available?
What is a correlated sub query?
What is buffrpool? Where we use it ?
Which command is used to remove all rows from a table?
Give some example of statistics collected during RUNSTATS?
COBOL 
