Interested to Buy Any Domain ? << Click Here >> for more details...
How do you check for a null value in a db2 column?
- 2 Answers
- 11770 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 is a storage group (stogroup)?
List out the data types available.
How do I import a csv file into db2?
What is iseries database?
What is the use of runstats in db2?
What is db2 command?
What are catalog tables in db2?
What are host variables in db2?
What is db2 optimizer?
How to retrieve rows from a db2 table in embedded sql?
How to check last update on table in db2?
What is database reorganization?
Explain in detail about buffer manager and its functionalities?
What is the difference between "db2ilist" and "db2 get instance" commands in DB2 Database Server?
In an sql table that is embedded, what is the procedure to retrieve rows that are part of a db2 table?
