Interested to Buy Any Domain ? << Click Here >> for more details...
how can u retrieve the data from null values using
applicaion program.
- 3 Answers
- 8766 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 are the various data types available in db2?
What is db2?
Following a db2 update statement, what is the quickest way to compute the total number of updated rows?
How do I change the column size in db2?
What is a cursor in programming?
by using cursors , we can access particular records from the table based on some condition, i want to delete those selected records, how can we write a query for this in the program?
What are the prerogatives?
What are iseries servers?
What is package in cobol db2?
What are bind parameters in db2?
Can one database have multiple instances?
What is the physical storage length of the data types date, time, and timestamp?
What is sqlca?
How many types of page locks can be held in db2?
What is copy pending status in db2?
