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

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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

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

851


What is the difference between nvl and coalesce?

802


What is the difference between cursor and select statement?

830


Explain the contents that are a part of dclgen.

859


How to find the number of rows in a db2 table?

839


How does a cursor work?

742


Is it possible using max on a char column?

834


What is the role of union all and union

861


can we view the access paths created by dbrm ? how ? thx

6635


What is db2 look?

777


what are bind concepts in db2 cobol?

822


How to test SQL -911 error while developing COB-DB2 program

7070


How can you validate Sql errors during cursor operation in db2 pgms and where do you code?

1951


For a db2 column that is being defined as decimal (11, 2), discuss the cobol picture clause.

847


What is the syntax for seeing the columns and data types of a table in the db2 database?

790