Interested to Buy Any Domain ? << Click Here >> for more details...
I have a DB2 table which has 1000 rows.after udatingg first
110 rows, my job abends. Now what I have to do if I want to
restart the job next time so that it should start updating
from 111th row (without updating first 110 rows again).
- 10 Answers
- 58404 Views
- Cap Gemini, Wipro, I also Faced
- E-Mail Answers
Answer Posted / krishna
declare the cursor with withhold option and we restart the
process from 111 record
| Is This Answer Correct ? | 3 Yes | 12 No |
Post New Answer View All Answers
How is deadlock resolved?
What is the syntax for seeing the columns and data types of a table in the db2 database?
What is the purpose of rollback and commit?
What is package in cobol db2?
What r the comman abends in db2, jcl and cobol???????
List out the buffer pools in db2
Mention the downsides of page level lock.
How do I add a column in db2?
What is null in db2?
Hi Everyone... Under the Logical files, when am working on multiple rec format logical file, I have joined two pf's using the multiple record format logical file concept, but when i run queried the LF only the first mentioned pf records are reflecting and I am not able to see any of the field records specified under the second pf. Kindly let me know whats the reason behind this. Below is the str of LF., R rec PFILE(LOGICAA) CUSTNO CUSTNAME BILL K CUSTNO R rec1 PFILE(LOGICAA1) CUSTNO ADD K CUSTNO .....
Which isolation level provides maximum concurrency?
What is the cobol picture clause of the db2 data types date, time, timestamp?
Which command is used to connect to a database in DB2 ? Give the Syntax.
What are iseries servers?
What is the difference between bind and rebind in db2?
