can we update the table by using cursors can anyone post
the query?

Answer Posted / bigben

yes you can
declare cursor using FOR UPDATE option

Is This Answer Correct ?    23 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What does reorg do in db2?

574


What is the latest version of ibm db2?

735


How do you simulate the explain of an embedded sql statement in spufi/qmf?

632


What language is db2 written in?

593


i tried to copy some records from microsoft excel to as-400 physical file through "Bosanova" emulation. Out of 14000 records only 12000 records copies and subsequently programe started to hang. Then, i closed the program forcefully. I did' under stand the problem. Also when i try to compile the physical file it is showing as "The file in use". How to overcome this problem?

2044






What is data manager?

603


How to test SQL -911 error while developing COB-DB2 program

6706


Why select is not preferred in embedded sql programs?

709


How to connect to db2 database from windows command line?

560


What is null indicator in db2?

599


Is schema the same as database?

625


What is the purpose of rollback and commit?

589


How do I add a column to an existing table in db2?

588


How would the varchar column remarks defined?

631


What is dbrm library?

576