How do you check for a null value in a db2 column?
Answer Posted / 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 |
Post New Answer View All Answers
What is iseries database?
Explain about rct.
What is nvl in db2?
Is ibm db2 free?
What is concurrency?
What is the difference between oracle and db2?
What do you mean by commit and rollback?
Which component is responsible for db2 startup and shutdown?
DB2 can implement a join in three ways using a merge join, a nested join or a hybrid join. Explain the differences?
What is database manager in db2?
Explain in brief how does db2 determine what lock-size to use?
What is dbrm? What it contains?
Explain correlated sub-queries.
What is innodb buffer pool?
What is rebind in db2?