which SQL comment successfully removes uncommitted changes from a DB2 database A) rollback B) delete C) drop D) decommit2 8138
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 43331
How to solved 818 error4 10013
In cursor program-1 can we create another cursor program-2 inside the cursor program-1.If yes how/no why ?2 5026
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 5851
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 5630
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 5898
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 21435
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 7701
what is main use of table space and index object? please its urgent5 10253
how we will do null data selection in cobol-db2 program2 4218
PLAN IS EXECUTABLE AND PACKAGE IS NOT EXECUTABLE . THEN WHAT IS THE USE OF PACKAGE?2 11410
WHAT IS MEANT BY COMMIT COMMAND?7 5981
Can we convert off line transformer to on line transformer
Why is water motor not taking the pressure? what is the problem?
What is product hierchey and where you assign in material master?
What is hyperlink?
difference bewteen reverse current and alternating current
Dear sir,i have completed M.sc,MBA.STILL I AM NOT GETTING WELL POSITION .I THINK ON LOW BUGET ON COURSE TO IMPROVE MY POSITION IN FINANCE FIELD.
What is mean effective press?
Short Answer on ______Transaction
what questions will be asked for 11/33KV licence interview APSEB hyderabad. Can any one share question and answers.
how client access the reports
Which Exchange determine Foreign Exchange/Currency Rate?
What is Chemical mutagenesis of plasmids and Why only Is there an alternative for FITC to label E. coli for FACS ?
difference between tcp ip and open system interconnection
who introduces the single entry format?
HOW TO ACTIVATE SEGMENT FILED IN ASSET ACCOUNTING ALSO CAN WE GET SEGMENT WISE FINANCIAL STATEMENTS IF YES THEN WHY WE ARE SPECIFYING BUSINESS AREA WISE FIN. STATEMENTS IN GLOBAL PARAMETERS (OBY6)