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
What are bind parameters in db2?
In an sql table that is embedded, what is the procedure to retrieve rows that are part of a db2 table?
For a db2 column that is being defined as decimal (11, 2), discuss the cobol picture clause.
What is database reorganization?
What is the physical storage length of date data type?
How is the value function used?
What is the picture clause of null indicator variable?
What are the two types of logging in the db2 database? Explain them.
What action db2 takes when a program aborts in the middle of a transaction?
What is a db2 tablespace?
What is db2 connect?
What is isolation level in db2?
What is a db2 cursor?
What is check constraint in db2?
What is ibm db2 database?