how can u retrieve the data from null values using
applicaion program.
- 3 Answers
- 9151 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 the physical storage length of the data types date, time, and timestamp?
What is a db2 collection?
Hello All, We have requirment to Replace BMC Db2 Load product thru CA FAST LOADPlus product. Do anyone have JCL to for FAST LOADPLUS and what all are thing need to take in consideration.
What is a data page?
What is coalesce in db2?
What are data types?
How do I handle -911 (deadlock) error in a db2 program so that the program will never abend?
which is the most efficient tablespace?? a.simple tablespace. b.partitioned tablespace. c.segmented tablespace. d.none of the above. please post answer with the reason.?
a cursor normally gets closed once we provide a commit . If u try to close the same cursor with close cursor command later after providing the commit will there be any sql-error.
This was related to -811 sqlcode, In a COBOL DB2 program which accesses employee table and selects rows for employee 'A', it should perform a paragraph s001-x if employee 'A' is present. In this case it gets -811 sqlcode, but still it process the paragraph s001-x. What could be wrong in my code.
how to delete perticular row from table for ex. how you will delete 3rd row from table please answer THANKS IN ADVANCE
One program calling 5 subprograms, its a cobol db2 program, after precompilation how many plans and packages will created?
COBOL 
