which SQL comment successfully removes uncommitted changes from a DB2 database A) rollback B) delete C) drop D) decommit
2 12831I 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 58430In cursor program-1 can we create another cursor program-2 inside the cursor program-1.If yes how/no why ?
2 8112How 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 108974. 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 9328if 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 11948Cursors 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 33020i 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 14134Post New Wipro DB2 Interview Questions
When reallocating memory if any other pointers point into the same piece of memory do you have to readjust these other pointers or do they get readjusted automatically?
How can Generative AI create value for enterprises?
What are the steps included in data integration process?
Why are data types important?
Explain how you can restrict multiple logins of user in sap? What are the thing you have to take care of while writing the id’s?
Why Accenture?
How much of your current client base consists of repeats and referrals?
What is hover app?
How are a file stored in neo4j?
What privilege is needed for a user to query tables in another schema?
19. Given a system that is described with the following equation, X=A+(B.(A̅+C)+C)+A.B.(D̅+E̅) a) Simplify the equation using Boolean Algebra. b) Implement the original and then the simplified equation with a digital circuit. c) Implement the original and then the simplified equation in ladder logic.
Can we use angularjs in android?
Explain various types of abap ui technologies
With what extension you can save the list of tests in a file to run in test batch runner?
A very strange fault i cam across today,that i never experienced not studied before, i need an answer for this. Phase to phase or line to line , L1,L2 & L3, voltages are 490VAC, but if i use line to ground , its again 490 VAC. . . whats the fault and theory behind of it?