Interested to Buy Any Domain ? << Click Here >> for more details...
How do you retrieve the data from a nullable column?
- 2 Answers
- 8666 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / s
DB2 application must also include a null indicator host
variable along with the host variable to contain the actual
value.
| Is This Answer Correct ? | 6 Yes | 1 No |
Answer / amol
We have to include one variable in working storage datatype
s9(4).
and while retriveing the value from nullable column we can
give ;host variable :null indicater. If value from column
is found to be null it will stoare in null indicater.
If we have not include the null indicater and value while
fetching found to be null the program will abend with
saqlcode -305.
| Is This Answer Correct ? | 3 Yes | 2 No |
How do you retrieve the first 5 characters of firstname column of db2 table emp?
How can you find out the # of rows updated after an update statement?
Parm value passed is PARM=(10,20). how do code linkage section and how would you add these two passes values and show result in cobol program.
Can we declare DB2 HOST variable in COBOL COPY book?
what is difference between Static call and Dynamic call? How does it function?
What is lock contention?
What is copy pending and check pending in db2?
What is DCLGEN?
How to update more then one record using update?
how to fetch first 100 rows in db2
What are data types?
How do u achieve record level locking in DB2 versions when record level locking is not allowed?
COBOL 
