Interested to Buy Any Domain ? << Click Here >> for more details...
How do you check for a null value in a db2 column?
- 2 Answers
- 11687 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 db2 catalog database?
How can you count the number of rows from a table tab?
What do you mean by cursor?
How do I delete a table in db2?
How to check table size in db2 sap?
How to connect to db2 database from windows command line?
How to access db2 tables in mainframe?
What is release/acquire in bind?
What does reorg do in db2?
How can tablespace be moved to another dasd volume that is allocated for that tablespace?
What is coalesce in db2?
How to find the maximum value in a column in the db2 database?
What is query_cache_limit?
what is utility for parm lib
What are catalog tables in db2?
