which SQL comment successfully removes uncommitted changes from a DB2 database A) rollback B) delete C) drop D) decommit2 8531
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 45683
How to solved 818 error4 10440
In cursor program-1 can we create another cursor program-2 inside the cursor program-1.If yes how/no why ?2 5320
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 6296
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 6003
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 6321
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 23045
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 8215
what is main use of table space and index object? please its urgent5 10826
how we will do null data selection in cobol-db2 program2 4470
PLAN IS EXECUTABLE AND PACKAGE IS NOT EXECUTABLE . THEN WHAT IS THE USE OF PACKAGE?2 12155
WHAT IS MEANT BY COMMIT COMMAND?7 6501
Name two types of cloud services?
How to write pl sql program in mysql command prompt?
if a pipe those configuration (ASTM c 76 class b 450mm dia 2500mm length) fixing for water course those lining of water is 7000 running meter. my question is that if 8 joints of pipe ls leakage and we have not permission to stop the water so which treatment we apply on joint in that in condition.
What is jquery datepicker in jquery?
Difference between nonoperating expentiture and non cash expenditure
differentiate between cdma and fdma?
What is a namenode in hadoop?
What does ctrl m do in onenote?
Where are stored procedures in sql server?
How to use hdfs put command for data transfer from flume to hdfs?
What do you mean by component scrap and how is it maintained in sap?
What is NGR . What is the purpose of 10 sec ,60 sec rating of NGR.
Testing activity which is performed to expose defects in the interfaces and in the interaction between integrated components is?
What is the difference between DATETIME2 and DATETIME?
Explain the different parts that constitute ASP.NET application?