Insert Table Select的意思|示意

Since there is no COMMIT between the INSERT and SELECT statement, potentially the deadlock is caused by a table scan.

由于INSERT和select语句之间没有COMMIT，死锁可能是由表扫描引起的。

Performing a SELECT statement on the table fetches the messages in the queue, and and doing an INSERT statement on the table sends the message.

在表上执行一条select语句就可以取得队列中的消息，而执行表上的insert语句就可以发送消息。

All that DB2 does is to allow an UPDATE, DELETE, and INSERT to appear in the from clause of a select and allow the user to chose which transition table shall be selected from.

DB 2所做的就是允许UPDATE、DELETE和INSERT出现在选择语句的from子句中，并允许用户选择应该从哪个过渡表进行选择。

Release the row locks so that other applications can SELECT, INSERT, UPDATE, and DELETE from the table (for example, use isolation level cursor stability or uncommitted read).

释放行锁，以便其他应用程序可以对表执行SELECT、INSERT、UPDATE和DELETE(例如，使用游标稳定性(curs or stability)隔离级别或未提交读(uncommitted read)隔离级别)。

In theory, you can perform select, insert, update, or delete statements against a table that is not yet redistributed in the database partition group.

理论上讲，可以在数据库分区组中尚未重分发的表上执行select、insert、update或delete语句。

You can now define multiple INSERT, DELETE, UPDATE, and SELECT triggers on a table and multiple INSTEAD OF triggers for the view.

现在可以在一个表上定义多个 INSERT、DELETE、UPDATE 和 SELECT 触发器，也可以在一个视图上定义多个 INSTEAD OF 触发器。