Can a array declared with an index be displayed(readable
format) in spool?
Answers were Sorted based on User's Feedback
Answer / ganesh
Since we can display content of array like below
Display Array(Idx)
But we can display index alone like
Display Idx
| Is This Answer Correct ? | 0 Yes | 2 No |
can we update the table by using cursors can anyone post the query?
How can you get the number of rows impacted by the last executed query?
If the cursor is kept open followed the issuing of commit, what is the procedure to leave the cursor that way?
When would you prefer to use VARCHAR?
4. A DB2 application is bound with uncommitted Read isolation level.It issues a request that retrieves 20 rows out of 200000 in the table. Which of the following descrbes the rows that are locked as a result of this request? a. None of the rows are locked. B.The retrieved rows are locked. C.The last row of the result set is locked. D.The rows not previously updated by another application are locked.
What does db2 blu stand for?
How are write I/Os from the buffer pool executed?
What is difference between isnull and coalesce?
What is runstats db2?
What are the prerogatives?
How to find the number of rows in a db2 table?
For update of a row in cursors, when do we move value into host variable in cobol progrm? is it before open or before fetch ?