Interested to Buy Any Domain ? << Click Here >> for more details...
db2 restart logic ?
- 1 Answers
- 12265 Views
- DELL, HTC, UHG, I also Faced
- E-Mail Answers
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 |
what is the use of commit ? and what is the syntax?
What is DCLGEN ?
What is the use of reorg in db2?
What is a DB2 bind?
Say CUST Table contains records like: CUSTNO CUSTNAME CUSTLOC 100 ABC SSS 200 XYZ 300 PQR 400 MNO WWW 500 CVV ------------- ------------- Now write a query to retrieve all records with CUSTLOC no data.
How do I add a column to a table in db2?
Differentiate between cs and rr isolation levels? Where do you specify them?
what is a plan and how do you refer the plan in the program?
What is a PLAN table? How will you use it? Give the various fields of PLAN table?
What is the function of the Data Manager?
What is cursor in dbms?
i tried to copy some records from microsoft excel to as-400 physical file through "Bosanova" emulation. Out of 14000 records only 12000 records copies and subsequently programe started to hang. Then, i closed the program forcefully. I did' under stand the problem. Also when i try to compile the physical file it is showing as "The file in use". How to overcome this problem?
COBOL 
