Interested to Buy Any Domain ? << Click Here >> for more details...
how can u retrieve the data from null values using
applicaion program.
- 3 Answers
- 8809 Views
- TCS, I also Faced
- E-Mail Answers
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 null in db2?
can any one expalin check point with an example?
what is a corelated subquerry?
What is a host variable?
What is the difference between spufi and qmf?
Request to database but database is not available so what is was abend is raised?
how can u retrieve the data from null values using applicaion program.
Explain about mirror activator disk mirroring?
What is usage pointer in cobol?
what is the differences between spufi and qmf and which is better?
4 Answers Accenture, Cap Gemini,
What is DCLGEN ?
What is the difference between IN subselects and EXISTS subselect?
COBOL 
