which SQL comment successfully removes uncommitted changes from a DB2 database A) rollback B) delete C) drop D) decommit2 8421
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 44903
How to solved 818 error4 10322
In cursor program-1 can we create another cursor program-2 inside the cursor program-1.If yes how/no why ?2 5240
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 6149
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 5908
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 6160
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 22473
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 8067
what is main use of table space and index object? please its urgent5 10671
how we will do null data selection in cobol-db2 program2 4399
PLAN IS EXECUTABLE AND PACKAGE IS NOT EXECUTABLE . THEN WHAT IS THE USE OF PACKAGE?2 11964
WHAT IS MEANT BY COMMIT COMMAND?7 6334
What proportion will you adopt while making allotments to advertisements and promotions from the total budget for marketing?
How to generate combined challan of pf?
For a given bulk solid how can the particle size distribution be determined?
Which important factors makes on page optimization better ?
What is 'goods movement'?
What is Web Adapter ?
for 32 dia (EQR HYSD steel) bar how much deduction for 45 and 90 degree band
How would you do the 'a user logge into production system, changes a table and logged out'. How would you track him?
how does an encoder work???
Difference between obj-list, obj-browse?
Suppose there are two requests for 2 different pages of same site and from 2 different browsers, How Web server recognise the different request and send result to the exact sender browsers.
Will customers that have licensed sap accounting powered by sap hana get a credit?
What is wealth maximisation
What is the difference between Pig and SQL?
State sufficient condition for differentiability of a function f(x,y) at a point (a,b)