Hi Dude,this is Ram.could any one tell me aboue CURRENT OF
clause in DB2.
Thanks in advance.......
Answers were Sorted based on User's Feedback
Answer / narayana reddy
current of is using in cursors.
whenever we want to update and delete table data after retrived
Is This Answer Correct ? | 4 Yes | 0 No |
Answer / kamlesh
Current of is used with cursors whenever v go for update in conjunction with for update of .
1.for update of in declare stmt
2.where current of in update query after fetching
Is This Answer Correct ? | 1 Yes | 1 No |
What do you mean by between and in? Is between inclusive of specified range values?
What is buffrpool? Where we use it ?
what is difference between Plan and Package
what is the syntax for FOR UPDATE CLAUSE in cursor declaration and how can u update using cursor? is it possible to update multiple rows at a time.
Is db2 relational database?
can any one give the list of some important sql abend codes which r frequently asked in interviews?
Why select is not preferred in embedded sql programs?
What is dpf in db2?
Hello All, We have requirment to Replace BMC Db2 Load product thru CA FAST LOADPlus product. Do anyone have JCL to for FAST LOADPLUS and what all are thing need to take in consideration.
What does this mean ? GRANT BIND,EXECUTE ON PLAN MK2 TO PUBLIC;
What is FREEPAGE and PCTFREE in TABLESPACE creation?
i have an employment table whch has salary,dept,name? i want salary b/w 1000 to 5000 can anyone pls say the query for ths ?
8 Answers Cap Gemini, CGI, EDS, IBM, Satyam, Wipro,