Answer / kumar

Transaction is any basic operation in DB2 like Insert,
Update, Delete is called transaction.

Commit: Make the changes permanently in database

Rollback: Get back the changes to the database.

Answer / s

Transactions are programs that run under the transaction
managers like CICS, IMS/TM. Transactions require excellent
response times.

Commit makes the database changes permanent that was made
during a unit of recovery ie. from one consistency point to
another.

Rollbacks reverses the changes made to the database during
a unit of recovery.

Answer / deepak

Transaction is any basic operation in DB2 like Insert,
Update, Delete is called transaction.

Commit-is use to save the records in data base for ex, I
have hundred records I got an abend in 50th records I can
save upto 49 records, and solve the issue and continue from
50th records,

Roll Back- it do not save the records if any abend occurs

Under what circumstances will DB2 allow an SQL statement to update more than one primary key value at a time?

1 Answers  

---

Do we need cursor for Count(*)?

4 Answers   iGate,

---

How do you retrieve the first 5 characters of firstname column of db2 table emp?

1 Answers  

---

What is the use of COMMAREA ?Minimum how much data we can pass from it?

7 Answers   Cap Gemini,

---

my project is insurance management system,how to explain my work environment in interview?

2 Answers   CGI, Value Labs,

---

What is the syntax for seeing the columns and data types of a table in the db2 database?

0 Answers  

---

In cursor program-1 can we create another cursor program-2 inside the cursor program-1.If yes how/no why ?

2 Answers   Wipro,

---

What do the initials DDL and DML stand for and what is their meaning?

2 Answers  

---

What is data manager?

0 Answers  

---

Is db2 a database?

0 Answers  

---

how to resolve -818 error. how to see timestamp token in load module and plan

4 Answers   IBM,

---

What is concurrency?

0 Answers  

---