Answer / jdriley

It will make the edits you made to the tables using INSERT,
UPDATE, and DELETE permanent.

Answer / abhisek

COMMIT will save/commit the changes made to a database
while INSERT, DELETE and UPDATE operations.

Answer / as

Commit will clear the content of DB2 buffers.

This point comes to use when you are updating huge nbr of
records without using commit. If the buffer become full
before you commit, then it will cause problem.

Answer / s

COMMIT will write the updates out to DASD.

Answer / urta

issuing the command "commit" means u have saved the
transaction..

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 Answers   Cap Gemini, CGI, EDS, IBM, Satyam, Wipro,

select 100 records from million records ?

2 Answers   Verizon,

What is meant by isolation level?

3 Answers  

What is the format (internal layout) of ?TIMESTAMP??

1 Answers  

how can u retrieve the data from null values using applicaion program.

3 Answers   TCS,

How do you simulate the explain of an embedded sql statement in spufi/qmf?

0 Answers  

What is temporal table in db2?

0 Answers  

While unloading huge amount of data from table. Suddenly job failed some error. Imagine 1M data unloading, In that 90% data unloaded only 10% left, So if want to unload the rest 10% what needs to be done? Whether do i need to start from top or anything ?

0 Answers   JPMorgan Chase,

in the CURSOR declare statement, if i am using an where clause and trying to compare the value with a host-varialble. EXEC SQL DECLARE C1 CURSOR FOR SELECT DEPTNO, DEPTNAME, MGRNO FROM DEPARTMENT WHERE ADMRDEPT = :ADM-DEPT Where would i need to provide value to this host-variable in the where clause. how could i pass value to this host-variable to check it.

2 Answers   iGate,

I have some 3 particular fields ..i want to know which all tables have those 3 fields. Is there any way to identify.. can we know by quering system tables..

5 Answers   CTS,

i tried to copy some records from microsoft excel to as-400 physical file through "Bosanova" emulation. Out of 14000 records only 12000 records copies and subsequently programe started to hang. Then, i closed the program forcefully. I did' under stand the problem. Also when i try to compile the physical file it is showing as "The file in use". How to overcome this problem?

0 Answers   TATA,

How to resolve -502 sql code in DB2?

2 Answers   Cap Gemini,