Interested to Buy Any Domain ? << Click Here >> for more details...
How do you retrieve the data from a nullable column?
- 2 Answers
- 8694 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 |
Mention the definition of cobol in varchar field.
db2 restart logic ?
Why do we bind in db2?
What is dynamic SQL?
What can the Locate option of the Repair Utility accomplish?
Is it possible using max on a char column?
Explain various types of locks in db2?
Can you Average the Characters ?
What is a cursor in programming?
Which command is used to remove all rows from a table?
On the create tablespace, what does the CLOSE parameter do?
What is read-only cursor?
COBOL 
