How do you check for a null value in a db2 column?

Answers were Sorted based on User's Feedback



How do you check for a null value in a db2 column?..

Answer / guest

You use a null indicator on the colunm and if the null
indicator = -1 then the column has a null value.

Is This Answer Correct ?    32 Yes 0 No

How do you check for a null value in a db2 column?..

Answer / 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

More DB2 Interview Questions

the dd name for ksds is dest1 and what is the dd name for alternate index of ksds ? a.dest b.dest1 c.dest1a d.dd1

2 Answers   Logica CMG,


quary for 1> fetch last record 2> fetch in reverse order 3> fetch last 5 row 4> fetch second last record (their is no primary key) i think concept of count can be use for this in 4th

5 Answers  


What do the initials DDL and DML stand for and what is their meaning?

2 Answers  


How to resolve deadlock issue

5 Answers   IBM,


When is the access path determined for dynamic SQL?

2 Answers  


How does one bind 2 versions of a CICS transaction with the same module name in two different CICS regions that share the same DB2 subsystem?

2 Answers  


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 ?...

0 Answers   IBM,


What are host variables in db2?

0 Answers  


What is declare cursor?

0 Answers  


What is data manager?

0 Answers  


What is a DB2 bind?

3 Answers  


What do you mean by between and in? Is between inclusive of specified range values?

0 Answers  


Categories