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 are the benefits of using the db2 database?
What is temporal table in db2?
what is db2 restart?
What is null indicator in cobol db2?
What does reorg do in db2?
How do you stop a db2 database in linux?
What is runstats and reorg in db2?
What does sqlcabc has?
How to check sequence on a table in db2?
How to fetch the last row from the table in SQL (db2)?
How do I connect my db2 database to ibm?
What is null value in db2?
What is db2 connect?
What are the contents of a dclmgen?
What is the difference between drop table and delete table?