how can u retrieve the data from null values using
applicaion program.
- 3 Answers
- 7939 Views
- TCS, I also Faced
- E-Mail Answers
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 a cursor in programming?
What is db2 connect?
How do you concatenate the firstname and lastname from emp table to give a complete name?
What is a db2 cursor?
What is database reorganization?
What is the purpose of using commit?
What is difference between rollback and commit?
Describe major components of db2?
What is innodb buffer pool?
Can we insert update delete in view?
Define declaration generator (dclgen).
Can you use max on a char column?
What is iseries database?
What does reorg do in db2?
How to execute stored procedures?
