db2 restart logic ?
Answer / ankitha
declare temp table with fields pkey and commit frequency.
then set commit frequency ie after 100 records it should
tabulate the temp table and in procerdure division read the
last pk value and should start updating after that pk value
and should delete this temp tble after the final commit or
stop run.
| Is This Answer Correct ? | 13 Yes | 1 No |
When is the skeleton cursor table created?
How to run db2 command in windows?
What is performance tuning db2?
What is the maximum length of sqlca?
What is nvl in db2?
What are data types?
There is a 5000 EMP in company.how we find out the 5th highest getting salary employee outof 5000 employes........
What is ACQUIRE/RELEASE in BIND?
How to resolve -407 sql code in DB2?
quary for 1> fetch last record 2> fetch in reverse order 3> fetch last 5 row 4> fetch second last record (their is no primary key) i think concept of count can be use for this in 4th
What is db2 purescale?
How is the value function used?