how can u retrieve the data from null values using
applicaion program.
Answers were Sorted based on User's Feedback
Answer / avinash
The null indicator would be assigned a value of -1 if the
fetched column has a null value.
Is This Answer Correct ? | 15 Yes | 0 No |
Answer / prachi
whenever you are retreving the data from null coloumn,
first you need to declare the null indicator in the working
storage section. and use this variable when you are
fecthing the data from null coloumn.
Is This Answer Correct ? | 9 Yes | 0 No |
Answer / 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 |
What is meant by union and union all?
What are the full forms of spufi and dclgen and why are they used?
What is load utility in db2?
What is the clustering index in the db2 database?
How does cobol compile db2 program?
What are bind parameters in db2?
What is the error code -803 ?
What else is there in the PLAN apart from the access path?
What is the maximum number of tables that can be stored on a Partitioned Table Space ?
what is SMP/E? and what are the major steps of it? thanks...
What is query for your birthday date should be in hours,minute and seconds format?
How is the SUBSTR keyword used in sql?