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

Answer Posted / 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       View All Answers


Please Help Members By Posting Answers For Below Questions

Can one database have multiple instances?

579


What types of tables are there in the db2 database?

547


How can you do the explain of a dynamic sql statement?

629


What is dbrm? What it contains?

672


What is explain plan in db2?

584






What is a db2 schema?

758


Explain in brief how does db2 determine what lock-size to use?

589


What is db2 connect?

595


What is a db2 package?

595


Mention the length of physical storage of the given data types of db2 – date, timestamp, time

579


Why cursor is used in db2?

568


What does db2 blu stand for?

656


What is universal database?

609


What is alias in db2?

561


What is a Foreign Key?

651