which SQL comment successfully removes uncommitted changes from a DB2 database A) rollback B) delete C) drop D) decommit
2 12936I 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 58753In cursor program-1 can we create another cursor program-2 inside the cursor program-1.If yes how/no why ?
2 8239How we create a tables in DB2 ?Previously client has using 7 letters for user id,now he wants to increase the letters from 7 to 12 for user id.How we can do it?
6 111414. A DB2 application is bound with uncommitted Read isolation level.It issues a request that retrieves 20 rows out of 200000 in the table. Which of the following descrbes the rows that are locked as a result of this request? a. None of the rows are locked. B.The retrieved rows are locked. C.The last row of the result set is locked. D.The rows not previously updated by another application are locked.
3 9458if suppose i am having an ACCOUNT table with 3 coloumns ACC. NO,ACC. NAME,ACC. AMOUNT . If a unique index is also defined on ACC.NO and ACC.NAME then write a query to retrieve account holders records who have more than 1 ACC.
8 12156Cursors can be declared in both working-storage & procedure division, Agreed. But is there any difference? If could you please suggest what is the difference. TIA
8 33386i have an employment table whch has salary,dept,name? i want salary b/w 1000 to 5000 can anyone pls say the query for ths ?
8 14382Post New Wipro DB2 Interview Questions
write a program in c++ for finding the given no. is odd or even without using any airthmatic operater?
How do you draw a straight line in word 2016?
Why use php artisan serve?
Difference between table delete and form delete?
hiii.... can any one provide me previous years question paper of hindustan petroleum for instrumentation engineering???
Define hadoop archives?
What would be the result of 3+2+”7″?
How does stack look in function calls? When does stack overflow? What can you do to remedy it?
What is package in pl sql with an examples?
What is high adherence steel bar? I have a general specification which refers to High Adherence steel bars, coils and meshes to BS EN 10080 and BS 4449 or BS 4483. Is this just general re-bar or is there something different about it? The spec originated in France.
What is the use of join command?
can anyone tell me what to say in interview when interviewer asks about "tell me about your framework in your project"?
What is a font style in powerpoint?
What are the properties of a string class?
What are the different types of partial agreements available in sap sd ?