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

Answer Posted / mee

yes its possible

Is This Answer Correct ?    0 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is image copy in db2?

564


Cursors can be declared in both working-storage & procedure division, agreed. But is there any difference? If could you please suggest what is the difference

737


Mention the way of highlighting as well as putting a cursor to use in a cobol program.

622


What are the bind parameters ibm db2?

618


What is the difference between "db2ilist" and "db2 get instance" commands in DB2 Database Server?

702






While unloading huge amount of data from table. Suddenly job failed some error. Imagine 1M data unloading, In that 90% data unloaded only 10% left, So if want to unload the rest 10% what needs to be done? Whether do i need to start from top or anything ?

1813


in my project..TEST is db2 8.1 version In PROD it is 7.1 if i do REORG in TEST.. can I use the same REORG jcl with out modification in PROD region (this is DB2 8.1 )? if not, what modification i need to do in my REORG control card?

1618


What is the difference between nvl and coalesce?

598


Define declaration generator (dclgen).

660


In case if at some point of time db2 is down, would that impact the pre-compilation process of a db2-cobol program?

571


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

589


When a COBOL-DB2 program in PRODUCTION is updating main tables and gone for long run, what have to do?

3112


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

583


What is meant by explain?

657


SQLCODE = -199, ERROR: ILLEGAL USE OF KEYWORD CHAR, TOKEN KEY was expected

10729