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
Can you tell me how can you find out the # of rows updated after an update statement?
What is the difference between nvl and coalesce?
What is the difference between cursor and select statement?
Explain the contents that are a part of dclgen.
How to find the number of rows in a db2 table?
How does a cursor work?
Is it possible using max on a char column?
What is the role of union all and union
can we view the access paths created by dbrm ? how ? thx
What is db2 look?
what are bind concepts in db2 cobol?
How to test SQL -911 error while developing COB-DB2 program
How can you validate Sql errors during cursor operation in db2 pgms and where do you code?
For a db2 column that is being defined as decimal (11, 2), discuss the cobol picture clause.
What is the syntax for seeing the columns and data types of a table in the db2 database?