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
What is image copy in db2?
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
Mention the way of highlighting as well as putting a cursor to use in a cobol program.
What are the bind parameters ibm db2?
What is the difference between "db2ilist" and "db2 get instance" commands in DB2 Database Server?
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 ?
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?
What is the difference between nvl and coalesce?
Define declaration generator (dclgen).
In case if at some point of time db2 is down, would that impact the pre-compilation process of a db2-cobol program?
What is dbrm? What it contains? When it will be created?
When a COBOL-DB2 program in PRODUCTION is updating main tables and gone for long run, what have to do?
How do I add a column to an existing table in db2?
What is meant by explain?
SQLCODE = -199, ERROR: ILLEGAL USE OF KEYWORD CHAR, TOKEN KEY was expected