which SQL comment successfully removes uncommitted changes from a DB2 database A) rollback B) delete C) drop D) decommit2 8319
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 44422
How to solved 818 error4 10217
In cursor program-1 can we create another cursor program-2 inside the cursor program-1.If yes how/no why ?2 5188
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 6059
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 5808
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 6053
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 22077
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 7924
what is main use of table space and index object? please its urgent5 10541
how we will do null data selection in cobol-db2 program2 4331
PLAN IS EXECUTABLE AND PACKAGE IS NOT EXECUTABLE . THEN WHAT IS THE USE OF PACKAGE?2 11794
WHAT IS MEANT BY COMMIT COMMAND?7 6212
how to determine H- zone in a column? where it will occur?
why are you selecting for the controlling area same company code?
Hi,Myself Aritra Kundu,has done MBA with Finance & hRM as specialization,recently cracked the SBI Clerical exam Nov 2009.So,now I am beat tensed about the type of questions I am likely to face in the broad.Since I am a managemnt student right from my graduation,Can anyone give some light about the question I am likely to encounter?
How to Provide Column Names Using the DRAW Command ?
If you want to output the results to the log file .. How to do?
In case of a constant mesh gear box, when the left dog clutch is slid to the left by means of the selector mechanism, a) Direct gear is obtained b) First gear is obtained c) Second gear is obtained d) Reverse gear is obtained
what is the meaning of MIN MAX?
What are the different BTG rules to achieve SAP Hybris Advanced Personalization?
I am going to HAL Online test for Computer Science. Can you please mail me the model question papers ?
How will you reduce the concrete flow after mixing the concrete
WHAT IS THE LIMIT OF MLT IN FINISHED PHARMA PRODUCT LIKE TABLET CAPSULE SYRUP CREAM
I am getting the (first) page number and the remaining records displayed in another list in another page BUT the PAGE Number is not displayed? What is the code/solution?
What Are The Steps Involved In The Concreting Process, Explain?
process chain is running I have to stop the process for 1 hour after that re runn the process where it is stopped? in multiprovider can I use aggregations
What are the components of Apache Spark Ecosystem?