How do you check for a null value in a db2 column?
- 2 Answers
- 11006 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 db2 tablespace?
What is rebind in db2?
Which component is used to execute the sql statements?
What is temporal table in db2?
How can you quickly find out the # of rows updated after an update statement?
Which component is responsible for processing sql statements and selecting access paths?
What is the difference between drop table and delete table?
Is db2 relational database?
Name the various locking levels available?
Define data page.
What is the cobol picture clause of the db2 data types date, time, timestamp?
How can deadlocks be resolved?
How to create backup table in db2?
Explain about cursor stability?
run jcl for cobol+db2 pgm?.. //jobcard //step001 exec pgm=ikjeft01 //systin dd * DSNSYSTEM(--------) RUN PROGRAM(MYPGMNAME) PLAN(-----), LIB(-------), PARMS(------) /* WHAT WILL U GIVE INSIDE THE BRACKETS... WHAT IS PLAN,PACKAGE,BIND?..PLAN N PACAKGES ARE GENERATED BY ?...
