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 in db2 database?
What is runstats utility in db2?
Can you tell me how can you find out the # of rows updated after an update statement?
Explain the function done by data manager?
What are the different types of base tables?
What is the maximum size of a char data type in db2?
What is the role of schema in the db2 database?
What is null indicator in cobol db2?
List out the three types of page locks that can be held.
is it compulsory commitment control in journal?
Which are the db2 tools to protect integrity of the database?
What is null value in db2?
What is meant by union and union all?
Which component is used to execute the sql statements?
What's The Percentage Free Space ?