which SQL comment successfully removes uncommitted changes from a DB2 database A) rollback B) delete C) drop D) decommit
2 12837I 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 58445In cursor program-1 can we create another cursor program-2 inside the cursor program-1.If yes how/no why ?
2 8121How 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 109224. 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 9333if 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 11955Cursors 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 33032i 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 14160Post New Wipro DB2 Interview Questions
What is .sh file in mac?
What is the shortcut key for pivot table?
When an integration model is deactivated, it deletes all the objects that are transferred in scm system? : supply chain management
who is your role modal give in few sentances
What are the main advantages of using asp.net?
Using which process does the blotting paper absorb ink?
What is time- sharing system?
What is reconciliation account?
You want to replicate only a subset of material group to srm product categories. How would you do it?
Is viewdidload only called once?
Define master data?
How to start and stop splunk service?
What are your long-term goals or career plans at Coventry Building Society?
Do I need to learn c++ before python?
Hi.... I applied for the post of scientific officer/Engineer-SB(Programmer).Please post the syllabus and sample papers.