db2 rollback to savepoint

Transaction ID in DB2 Author: anonymous time: Source: Internet Editor: XiaoYu Abstract: The transaction ID in DB2

transaction ID in DB2 Author: anon Time: 2005-08-12 17:39 Source: Internet Zebian: Small fishing Summary: Transaction IDs in DB2

Work Unit and storage point Unit of work (uow)Also knownTransactionsIt is an applicationProgramProcessRecoverable)Operation Sequence. A typical uow example is a simple bank transfer transaction, that is, transferring funds from one account to

Main content :Data Definition Language DDL FocusData manipulation language DML FocusDQL Focus of data query language---transaction control language TCL---database control Language DCL---primary key (primary key)---data redundancy (a separate table

I believe everyone knows about the DB2 stored procedure. The following describes two pointer loops in the DB2 stored procedure. I hope this will help you learn about the DB2 stored procedure. Pointer loops in DB2 stored procedures: There are two

The following articles mainly analyze the practical skills of the DB2 unlimited activity log policy correctly. When the database is created for the first time, there are three log files called the main log files, assigned as part of the creation

Global declarative Temporary tables Temporary tables are often used to store temporary data and intermediate results. Because they do not require logging and are not present in the system catalog, they can improve performance. In addition, because

When the database was first created, there were 3 log files, called primary log files, that were assigned as part of the creation process. On Linux and UNIX platforms, these log files have a total of 1,000 pages of 4kb in size, and on the Windows

There are three types of Java transactions: JDBC Transaction, JTA (Java Transaction API) transaction, container transaction.A transaction is a uniform commit or rollback operation for a series of database operations (such as inserting multiple data),

First episode:#目前主流数据库 Microsoft Sqlsever and access MySQL ad2 Sybase informix Oracle #小型数据库: Access: Less than 100 people with low security requirements #中型数据库: Mysql,sqlsev ER: Load at 5000 to 15000 #大型数据库: sybase,oracle,db2: Load can handle