Interested to Buy Any Domain ? << Click Here >> for more details...
how can u retrieve the data from null values using
applicaion program.
- 3 Answers
- 8728 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 |
Assuming that a site's standard is that pgm name = plan name, what is the easiest way to find out which Will precompile of an DB2-COBOL program bomb, if DB2 is down?
If anyone has IBM Certification Dumps pls forward to me & also let me know what are the Certification Codes that are available in DB2
What happens to a tablespace when its recovery infromation has been removed and a full recovery is no longer possible?
suppose in my table 10 rows are there , i want to update odd rows salary as 90000 ? how u do it ? any one help me ? what do we use here cursor-fetch or normal sql ?
explain about index with examples
What is universal database?
How do you prepare a COBOL + DB2 program from coading till execution ?
What does db2 stand for?
Which command is used to remove all rows from a table?
what is rebinding ?
Hi, i would like to start a new carrier in DB2 DBA.Which and what all step should i have to take..?
Where do you specify them?
COBOL 
