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

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

Question Posted / rkrish

2 Answers
5241 Views
I also Faced
E-Mail Answers

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

where will u check for sqlcode ?

2 Answers TCS,

What is dynamic SQL?

1 Answers ADP,

What are types of indexes?

0 Answers

Where to download IBM DB2 Certification Dumps for the below: C2090-311 : IBM DB2 10.5 DBA for LUW Upgrade from DB2 10.1 C2090-312 : IBM DB2 11 DBA for z/OS C2090-313 : DB2 11 Application Developer for z/OS C2090-317 : DB2 11 System Administrator for z/OS C2090-541 : DB2 9.7 DBA for Linux UNIX and Windows C2090-543 : DB2 9.7 Application Development C2090-544 : DB2 9.7 Advanced DBA for LUW C2090-545 : DB2 9.7 SQL Procedure Developer C2090-546 : DB2 9.7 Database Administrator for Linux UNIX or Windows Upgrade C2090-610 : DB2 10.1 Fundamentals C2090-611 : DB2 10.1 DBA for Linux, UNIX, and Windows C2090-612 : DB2 10 DBA for z/OS C2090-614 : DB2 10.1 Advanced DBA for Linux UNIX and Windows C2090-615 : DB2 10.5 Fundamentals for LUW C2090-617 : DB2 10 System Administrator for z/OS C2090-730 : DB2 9 Family Fundamentals C2090-733 : DB2 9 Application Developer C2090-735 : DB2 9.5 SQL Procedure Developer C2090-737 : DB2 9 System Administrator for z/OS Exam

1 Answers Mphasis,

What is the purpose of using commit?

0 Answers

Can we insert update delete in view?

0 Answers

What is SPUFI?

4 Answers

What is release/acquire in bind?

0 Answers

How can you compare table column after update and before update?

5 Answers Satyam,

What does a deadlock mean in DB2?

0 Answers

I HAVE 500 ROW TO UPDATE I WOULD LIKE TO USE ROLLBACK ALONG WITH COMMIT.WHAT IS THE SYNTAX TO CODE COMMIT AND ROLLBACK FOR EVERY 100 ROWS.AND HOW THE CURSOR ROLLBACK TO THE LAST COMMITTING POINT.

0 Answers ITC Infotech, Syntel,

How can i install db2 9.x on AIX based system..? plz reply the detailed steps involved....?

0 Answers IBM, TCS,

For more DB2 Interview Questions Click Here