Interested to Buy Any Domain ? << Click Here >> for more details...
Suppose if I need to update a column, how you do that using
cursor?
- 2 Answers
- 8313 Views
- Verizon, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / bobby
continuation of previous answer,
after cursor declaration, open the cursor and fetch the cursor. When the condition for update is satisified isue EXEC SQL UPDATE CURRENT OF.
| Is This Answer Correct ? | 6 Yes | 0 No |
Answer / sandy
EXEC SQL DECLARE X CURSOR FOR
SELECT * FROM ABC
FOR UPDATE OF <COLUMN> ==>If we know the column we would
like to update.
| Is This Answer Correct ? | 4 Yes | 0 No |
What does the REORG Utility do?
What is consistency token in db2?
Generally if I want to select the names starting with c I need to use c% But how could I code to select the data which contains % as a part of data.
What is buffrpool? Where we use it ?
What information is held in SYSIBM.SYSCOPY?
What is a view? Why use it?
How can we define a table? How can we apply SEARCH ALL on it ?
On which levels locks can be applied?
What is meant by isolation level?
How can you quickly find out the # of rows updated after an update statement?
if any of the column names is provided wrong, where do you get the error(during precompilation or during Bind)
What is pagespace?
COBOL 
