Interested to Buy Any Domain ? << Click Here >> for more details...
how can u retrieve the data from null values using
applicaion program.
- 3 Answers
- 8734 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
Define buffer pool.
What is the purpose of rollback and commit?
What is the use of commit in db2?
What are the various isolation levels possible?
How do you concatenate the firstname and lastname from emp table to give a complete name?
How does coalesce work?
What is netezza database?
What is the physical storage length of the data types date, time, and timestamp?
What is universal database?
What is the role of schema in the db2 database?
Why cursor is used in db2?
What is the physical storage length of time data type?
What are sqlcodes –803,-805, -811, -818,-904,-911,-913,-101, +100?
How does cobol compile db2 program?
What is the picture clause of null indicator variable?
