which SQL comment successfully removes uncommitted changes from a DB2 database A) rollback B) delete C) drop D) decommit
2 11455I 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 54643In cursor program-1 can we create another cursor program-2 inside the cursor program-1.If yes how/no why ?
2 6978How 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 88234. 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 7872if 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 9292Cursors 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 29784i 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 11749Post New Wipro DB2 Interview Questions
Can you forward the same port to multiple ips?
What does valet park and link command do?
What is #region in c#?
Define stepper motor. What is the use of stepper motor?
What type of boss you would like to work with?
Describe the Myoblast or cardiomyocyte culture ?
Give the difference between Drop and Truncate in CQLSH?
What are the criteria for accounting job?
What are your long term and short term career goals ? What has influenced your thinking while evaluating your career options
Explain what is auto dialer? : insurance cold calling
What will happen if we don’t have no-args constructor in entity bean?
financial managers are responsible for obtaining and using funds in a way that will maximize the value of the firms. Please explain.
What is the purpose of the wow6432node subkey in the windows registry?
How ASP.NET page works?
Tell me something about IN call Flow and what is the difference between the flows in both GSM and CDMA technologies?