Interested to Buy Any Domain ? << Click Here >> for more details...
How do you retrieve the data from a nullable column?
- 2 Answers
- 8920 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 |
is it possible to get -811 error when you use cursors. why?
When is the skeleton cursor table created?
Explain the use of the WHERE clause.
What is a page?
What are types of indexes?
On which levels locks can be applied?
what is diffrence b/w file-aid tool and file-aid utility???
What do you mean by rollback?
In my table having 100 Rec. How can I delete the 7th row?? (we don't know what is data inside the table)
What do you mean by cursor?
What are union and union all?
How many Buffer pools are there in DB2 and what are they?
COBOL 
