Interested to Buy Any Domain ? << Click Here >> for more details...
How do you check for a null value in a db2 column?
- 2 Answers
- 11667 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 optimizer?
Explain db2.
What is a cursor in programming?
What is sqlca?
What is the role of schema in the db2 database?
How can you do the explain of a dynamic sql statement?
What is rct?
How do I delete a table in database?
What are types of indexes?
What is a collection in db2?
in my project..TEST is db2 8.1 version In PROD it is 7.1 if i do REORG in TEST.. can I use the same REORG jcl with out modification in PROD region (this is DB2 8.1 )? if not, what modification i need to do in my REORG control card?
what are bind concepts in db2 cobol?
What is check constraint in db2?
Explain about rct in db2?
What is runstats db2?
