which SQL comment successfully removes uncommitted changes from a DB2 database A) rollback B) delete C) drop D) decommit2 8470
I 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 45331
How to solved 818 error4 10388
In cursor program-1 can we create another cursor program-2 inside the cursor program-1.If yes how/no why ?2 5280
How 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 6217
4. 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 5958
if 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 6246
Cursors can be declared in both working-storage & procedure division, Agreed. But is there any difference? If could you please suggest what is the difference. TIA8 22797
i 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 8133
what is main use of table space and index object? please its urgent5 10749
how we will do null data selection in cobol-db2 program2 4425
PLAN IS EXECUTABLE AND PACKAGE IS NOT EXECUTABLE . THEN WHAT IS THE USE OF PACKAGE?2 12062
WHAT IS MEANT BY COMMIT COMMAND?7 6410
How to authorize the user to run a process or report?
what is a corporate chart of accounts and its purpose?
hai friends .i applied for icici po callfor in july2010.i have been sortlisted for icici bank po and they fix the appoinment on july 31.so i don't know whether it is an interview or test or gd.can any body attend it already .please tell about it and how to prepare.my email id is email@example.com
What is the SAP Hybris Search feature?
What are the different types of sapscript symbols?
Why to use figure tag in html5?
What are the features of c languages?
Give an example of interface from your project explaining why you used it?
What is Audit Trail?
How we can Evaluate Market Potential and Risk? Especially in Telecom and Banking Sector
Is it possible to schedule an individual plan? What is the t code?
which has high compressive strength between hollow block and brick masonry?
We have wrongly used road permit of other party in consignment to kolkatta.The road permit used is the party from Kolkatta.How to resolve the issue ??
What is test object model in quicktest professional?
how test transfomer(3 phase75kva) by megger