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

Answer Posted / 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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Mention the definition of cobol in varchar field.

867


Which component is responsible for db2 startup and shutdown?

794


What is a plan and package in db2?

819


What is the difference between spufi and qmf?

800


What is concurrency?

893


What is dbrm? What it contains? When it will be created?

773


What is the max length of sqlca?

945


What is the difference between cursor and select statement?

816


How to find primary key of a table in db2?

796


What is the role of data manager in the db2 database?

829


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.

2955


What are the bind parameters ibm db2?

792


For a db2 column that is being defined as decimal (11, 2), discuss the cobol picture clause.

840


What does sqlcabc has?

775


How to create backup table in db2?

833