can we update the table by using cursors can anyone post
the query?
Answers were Sorted based on User's Feedback
Answer / bigben
yes you can
declare cursor using FOR UPDATE option
Is This Answer Correct ? | 23 Yes | 0 No |
Answer / 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 |
Answer / amar
DECLARE
INT NUMBER:=0;
CURSOR C1 IS
SELECT COL1,COL2 FROM TABLE_NAME;
BEGIN
FOR RC IN C1 LOOP
UPDATE TABLE_NAME SET COL_NAME=RC.COL1,COL_NAME=COL2;
CNT:=CNT+1;
END LOOP;
END;
Is This Answer Correct ? | 1 Yes | 0 No |
Answer / siri
suppose we want update ename in emp table using cursor....
declare crsorname cursor for
select * from emp
where dept='d005'
for update of ename....
upate emp
set ename=:ename
where current of cursor
Is This Answer Correct ? | 0 Yes | 0 No |
How to check sequence on a table in db2?
What's the Maximum Length of SQLCA and what's the content of SQLCABC?
What is dclgen (declaration generator)?
How to find last record before record through SQLRPGLE?
How can tablespace be moved to another dasd volume that is allocated for that tablespace?
What information can you find in SYSIBM.SYSLINKS table?
Mention the length of physical storage of the given data types of db2 – date, timestamp, time
how to execute qcmdexc in rpgle?plz write code also?
Mention the definition of cobol in varchar field.
how to u check the query is executing or not ?where will u check for sqlcode ?
Differentiate between cs and rr isolation levels? Where do you specify them?
Mention data types used in db2 ?