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 is the max length of sqlca?
Explain what are the various isolation levels possible?
Why do chiropractors use drop table?
How do I add a column to an existing table in db2?
What are packages in db2?
Explain about dbrm.
what is db2 restart?
What is table space in db2?
What is dbrm in db2 database?
Cursors can be declared in both working-storage & procedure division, agreed. But is there any difference? If could you please suggest what is the difference
How do I add a column to a table in db2?
What is isolation level in db2?
How does a cursor work?
can all users have the privilage to use the sql statement select * (dml)?
Is db2 a database?