is select statement considered as a transaction ?

[balucec]

Is the select statement in SQL considered as a transaction.? What is a transaction? (pls explain i know the conventional definitions)

[Amarnath Reddy N]

Yes select statement in SQL considered as a transaction. All statements in DB2 initiates a transaction,

Transactions in DB2 are implied rather than explicitly defined.
A transaction is essentially all the work from one persistence
point to another. A persistence point is where data is actually
written to the database or not written, i.e COMMIT or ROLLBACK.

In other words a transaction is all the work from one COMMIT /
ROLLBACK to the next COMMIT / ROLLBACK.

DB2 prefer to use Unit of Work (UOW) instead of transaction