can we update the table by using cursors can anyone post
the query?
Answer Posted / diana
Yes you can update the table using cursor....
for eg: if you want to update 3 columns like A,B,C the you
can write as:
Update Table_name
Set A = :Host varaible(value)
B = :Host varaible(value)
C = :Host varaible(value)
where current of C1(Cursor name)
Is This Answer Correct ? | 9 Yes | 0 No |
Post New Answer View All Answers
How can we retrieve the total number of records in RPG & CLLE?
What is a plan and package in db2?
What r the comman abends in db2, jcl and cobol???????
What is scrollable cursor in db2?
i tried to copy some records from microsoft excel to as-400 physical file through "Bosanova" emulation. Out of 14000 records only 12000 records copies and subsequently programe started to hang. Then, i closed the program forcefully. I did' under stand the problem. Also when i try to compile the physical file it is showing as "The file in use". How to overcome this problem?
define clustering index.
How do you concatenate the firstname and lastname from emp table to give a complete name?
What is difference between isnull and coalesce?
What is db2 optimizer?
What is node in db2?
Mention the different locking levels that are available in db2.
How to execute stored procedures?
What is query_cache_limit?
What are the different types of base tables?
What is copy pending status in db2?