How do you retrieve the data from a nullable column?
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 |
what is check point and restart Logic ? why do we go for that ??
What is the cascade rule and how does it relate to deletions made with a subselect?
What is a db2 table?
how to u check the query is executing or not ?where will u check for sqlcode ?
How do I start db2 in windows?
What is Reorg Recovery? when will you run it?
Suppose the outcome of executing a query results in a row having null. Based on the answer how you use it? Its declaration and inclusion?
Define sqlca.
What is a base table?
What is the use of db2?
cursor with hold explain ?
What can the Locate option of the Repair Utility accomplish?