Interested to Buy Any Domain ? << Click Here >> for more details...
can we update the table by using cursors can anyone post
the query?
- 5 Answers
- 11101 Views
- DELL, HCL, I also Faced
- E-Mail Answers
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 is load utility in db2?
What is ibm db2 database?
What is cursor stability in db2?
How can record locking be achieved in those DB2 versions which do not support it?
How many types of page locks can be held in db2?
What are the bind parameters ibm db2?
How do I start db2 in windows?
How to find schema of a table in db2?
How does db2 sample database connect?
What is rct?
What do you mean by rollback?
What language is db2 written in?
What is query_cache_limit?
What is a trigger in the db2 database?
Suppose pgm A calling Pgm B .Pgm B has some Db2 program. at the time of compilation should plan and package will be created for both A and B or only B? What is the concept?
