How do you leave the cursor open after issuing a COMMIT?
(for DB2 2.3 or above only)
Answers were Sorted based on User's Feedback
Answer / s
If you like the cursor maintain the position even after the
commit, CURSOR is defined WITH HOLD.
Is This Answer Correct ? | 4 Yes | 0 No |
What is meant by dclgen?
have 3 tables table1, table2 and table3 which contains employee information. table1 is master table, table2 contains emp details like emp no and so on, table 3 contains emp salary. so if any emp leave company between 25th - 30th of every month it has to get updated in tables. but it is not getting updated. What is the reason.
What is performance tuning db2?
In case if at some point of time db2 is down, would that impact the pre-compilation process of a db2-cobol program?
how to delete perticular row from table for ex. how you will delete 3rd row from table please answer THANKS IN ADVANCE
I am getting a error multiple row fetched while executing a Cobol-DB2 program.How can I solve it without using a cursor.
What is package in db2 mainframe?
How can you count the number of rows from a table tab?
what is the certification that has a good value for a practioner in mainframes but not habving much knowledge on db2 related stuff?
What is a Foreign Key?
0 Answers Tavant Technologies, Zensar,
i have cobol+ db2 program but it contains n number of subprograms for this how many dbrm members i need to mention in bind process
when does the SQL statement gets executed when you use cursor in the application programming ?