How do you check for a null value in a db2 column?
- 2 Answers
- 11258 Views
- I also Faced
- E-Mail Answers
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's The Error Code For Unique Index Voilation?
List out the data types available.
What is bufferpool in db2?
Can we insert update delete in view?
What is consistency token in db2?
Explain in brief how does db2 determine what lock-size to use?
How to find schema of a table in db2?
Describe major components of db2?
Give the name of some fields form sqlca.
What is db2 instance?
How can you validate Sql errors during cursor operation in db2 pgms and where do you code?
What is the default page size of buffer pools?
What are catalog tables in db2?
What is the purpose of using commit?
What is host variable in db2 cobol?
