how can u retrieve the data from null values using
applicaion program.
Answer Posted / bhavani
When we retrieve data from a nullable field, we need to
have a null indicator declared in the working storage.
WS-NULL-INDICATOR s9(04) comp
And after you have fetched the value for that column,
we need to check the value of the null indicator.
It can have the following values
-2 - Exceptional condition
-1 - Null Value is present in that field
0 - Not null
| Is This Answer Correct ? | 9 Yes | 0 No |
Post New Answer View All Answers
What is dbrm? What it contains? When it will be created?
Mention the length of physical storage of the given data types of db2 – date, timestamp, time
How does a cursor work?
What's The Error Code For Unique Index Voilation?
What is db2 bind process?
What is table space in db2?
What is a collection in db2?
What is runstats db2?
How do I create a view in db2?
Can we delete records from view?
What is release/acquire in bind?
What is db2 connect?
What is a db2 tablespace?
How to fetch the last row from the table in SQL (db2)?
What is netezza database?