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

What are the four lockable units for DB2?

1 Answers  


if i made sme changes in sub pgm wht r the things to be done for this ?

1 Answers   TCS,


Following a db2 update statement, what is the quickest way to compute the total number of updated rows?

0 Answers  


What's The Error Code For Unique Index Voilation?

0 Answers   IBM,


What language is db2 written in?

0 Answers  


How does one remove entries from the SCT02 table?

1 Answers  


What is with ur in db2?

0 Answers  


Can you tell me how can you find out the # of rows updated after an update statement?

0 Answers  


Where do you specify them?

0 Answers  


How can you split a table in to exactly half?

7 Answers   HSBC,


What is the physical storage length of the data types date, time, and timestamp?

0 Answers  


How do I change the column size in db2?

0 Answers  


Categories