which SQL comment successfully removes uncommitted changes from a DB2 database A) rollback B) delete C) drop D) decommit2 8233
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 43942
How to solved 818 error4 10124
In cursor program-1 can we create another cursor program-2 inside the cursor program-1.If yes how/no why ?2 5105
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 5972
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 5724
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 5974
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 21770
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 7827
what is main use of table space and index object? please its urgent5 10407
how we will do null data selection in cobol-db2 program2 4276
PLAN IS EXECUTABLE AND PACKAGE IS NOT EXECUTABLE . THEN WHAT IS THE USE OF PACKAGE?2 11646
WHAT IS MEANT BY COMMIT COMMAND?7 6098
Is there Disqualification of Auditor u/s 139 of Companies Act 2013 if the auditor is indebted towards the company to be appointed as an auditor, if amount exceeds more than Rs.1000 as against the provision related to Companies Act, 1956 ?
Program to check whether a word is a sub-string or not of a string typed
Encapsulation of attributes and operations inside objects makes it easy to obtain object state information during testing. is it true.explain
What is replication difference between wi2k and win2k3 replication?
how many maximum session supports to multiload in teradata ??
What is the process to change the files at arbitrary locations in HDFS?
Which sex(es) of flowers in the Cucurbitaceae have nectary disks? Why?
Why rdt and thermocouple both give different output .and one things more, how to generate ohm or mili volt plz mail me email@example.com
I am importing dc-dc converters from singapore to india. how much tax will be applicable towards Custom duty.and the rates of the custom duty.
How to detect the computer name?
If gas turbine is operating on part load, how droop will affect the output with respect to frequency.
why we have to use particular buffer only for dissolution instead of using cheap buffer.
The lowest allowable insulation resistance?
What other TCP setting can you modify besides MTU to shorten packets
How to transfer request which is created directly on quality server & has to be moved to in production server?