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



Hi Dude,this is Ram.could any one tell me aboue CURRENT OF clause in DB2. Thanks in advance.........

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

Hi Dude,this is Ram.could any one tell me aboue CURRENT OF clause in DB2. Thanks in advance.........

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

Post New Answer

More DB2 Interview Questions

How can you display the current date & current time ?

7 Answers   Cap Gemini,


What is a view? Why use it?

2 Answers  


What is dclgen in db2?

1 Answers  


What does db2 plan contain?

1 Answers  


What happens to the PLAN if index used by it is dropped?

1 Answers  


What is a Foreign Key?

1 Answers   Tavant Technologies, Zensar,


What is data manager?

1 Answers  


is it possible to get -811 error when you use cursors. why?

2 Answers   IBM,


What do you mean by commit and rollback?

1 Answers  


What's the Maximum Length of SQLCA and what's the content of SQLCABC?

2 Answers  


What are union and union all?

1 Answers  


In an sql table that is embedded, what is the procedure to retrieve rows that are part of a db2 table?

1 Answers  


Categories