which SQL comment successfully removes uncommitted changes from a DB2 database A) rollback B) delete C) drop D) decommit
2 9636I 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 50509In cursor program-1 can we create another cursor program-2 inside the cursor program-1.If yes how/no why ?
2 6134How 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 76464. 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 6901if 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 7840Cursors 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 27014i 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 10110Post New Wipro DB2 Interview Questions
Discuss the various functions of marketing.
How does SAP get to know whether the material is available or not? how does it determine MAD? What exactly happens in sending TOR?
What are different types of windows in computer?
How do you tell if your computer is 32 or 64 bit?
What is a request object?
What are the gpc and the gpt?
Is purchasing information (vendor, date of purchase, etc.) Copied from mm to the equipment when it is being created ?
What is aggregate function in excel?
where do we use htaccess?
provide example where initiated and followed up on a project until its completion ?
How do I format a cell in excel to match another cell?
What is resolver in angular 2?
what are the statements uses proper for loop syntax? : Adobe flash
What is the name of the system variable that holds the contents of the selected line in interactive reporting?
What is @controller and @restcontroller?