Due to the large amount of data in the audit log table, a single INSERT statement will usually fail because the data per transaction exceeds the log file size of the database system.
因为审核日志表格里有大量的数据，单独的insert语句通常会失败，这是因为每个事务的数据超过了数据库系统里的日志文件的容量。
The DB2 transaction associated with an upload included generating a unique document ID, logging the upload in the activity history table, and executing a SQL INSERT into 18 tables.
与上传相关联的DB2事务包括生成惟一的文档id、在活动历史表中记录这次上传以及对18个表执行SQLINSERT。
Note: Alternatively you can create a database trigger to capture every INSERT on your table and tell it to validate the data as XML using the XMLVALIDATE function before performing the INSERT.
注意：您也可以选择创建一个数据库触发器来捕捉表上的每个INSERT操作，并告诉它在执行INSERT之前使用XMLVALIDATE函数验证XML数据。
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语句就可以发送消息。
Since the enhanced MDC INSERT performance feature is implemented by specifying it as an option on a table's LOCKSIZE parameter, this means that it can be enabled on a per table basis.
由于增强的MDCINSERT性能特性是通过指定它作为一个表的LOCKSIZE参数上的一个选项来实现的，这意味着它可以在每个表上启用。
You can see from the form of the INSERT INTO in Listing 5 that a table had been created to correspond with the element in our DTD.
可以从清单5中INSERT INTO的形式看出，对应dtd中的元素创建了一个表。
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子句中，并允许用户选择应该从哪个过渡表进行选择。
Drag the BOOKSTORE table onto the pane to create a new INSERT statement.
将BOOKSTORE表拖到窗格上以创建一个新的insert语句。
When DB2 encounters an INSERT on an MDC table, it looks for a free block.
当DB 2碰到对mdc表的INSERT操作时，它寻找一个空闲的块。
In table 6, the INSERT into the Orders table fails due to a foreign key constraint violation on custno.
在表6中，对orders表执行insert语句失败，因为custno违背了外键约束。
Since this is a table operation, tooling generates insert, update, and delete operations automatically.
由于这是一项表操作，因此工具将自动生成insert、update和delete操作。
Upon arrival, a customer-written program adds the records to a staging table then USES insert statements to add the records to the fact table.
当该文件到来时，用户编写的一个程序将这些记录添加到一个staging表中，然后使用insert语句将这些记录添加到事实表中。
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触发器，也可以在一个视图上定义多个INSTEADOF 触发器。
In most cases, well-suited SQL statements are very simple SELECT statements that reference only a single table or are INSERT, UPDATE, and DELETE (UID) operations that are executed many times.
在大多数情况下，非常适合使用参数标记的sql语句要么是非常简单的SELECT语句(只引用一个表)，要么是被多次执行的INSERT、UPDATE和DELETE (uid)操作。
FREEPAGE should be used if your table rows are larger than half a page, since you cannot INSERT a second row on a page in such circumstances.
如果表行大于页宽的一半，则应该使用FREEPAGE，因为在那样的环境下不能在一页上再INSERT一行。
Since there is no COMMIT between the INSERT and SELECT statement, potentially the deadlock is caused by a table scan.
由于INSERT和select语句之间没有COMMIT，死锁可能是由表扫描引起的。
The use of a staging table can provide improved performance for some insert scenarios.
通过使用staging表可以为某些场景下的insert提高性能。
When a specified SQL operation — a DELETE, INSERT, or UPDATE — occurs on a table, a trigger can be activated that defines a set of actions.
当一个指定的SQL操作(如DELETE,INSERT，或者是UPDATE操作)作用于某张表时，一个定义了一组操作的触发器就可以被激活。
Instead, you could load the 1M rows into a staging table, then run eight concurrent insert ...
相反，您可以将1M 的行装载到一个staging表中，然后运行8 条并发的insert ...
If one or more insert triggers are defined on a table, each insert will result in the execution of the actions prescribed in the trigger definition.
如果在一个表上定义了一个或多个进行insert操作的触发器，那么每次的insert都将引起触发器定义中的动作的执行。
Use Load and a staging table or a multithreaded application to achieve Insert parallelism.
使用Load和staging表或多线程应用程序，以实现Insert的并行性。
The addProduct() method in Listing 9 accepts a new product record as an array of key-value pairs and then uses the Zend_Db object's insert() method to write this record to the database table.
清单9中的 addProduct() 函数接收一个新产品记录作为键-值对数组，然后使用 Zend_Db对象的insert() 函数将记录写入到数据库表中。
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语句。
Now, set the cursor on a new line, and select Insert -> Table.
现在，将光标定位在新的一行上，并选择Insert->Table。
In Oracle 10g, if there is a BEFORE INSERT TRIGGER and a NOT NULL constraint on a table, then the BEFORE TRIGGER is executed first, and then the constraint check is performed.
在Oracle10g中，如果表上同时存在BEFORE INSERT触发器和NOT NULL约束，那么先执行BEFORE触发器，然后执行约束检查。
An after-insert trigger on the IWH.EDITION table is not useful, as only rows with a status value of start would be intercepted.
edition表上的after - insert触发器并非很有用，因为它只能截获其status值为start的记录行。
But what do you do if you want to encapsulate the insert of a new row into a table of DB2 and IDS in a single transaction?
但是如果您需要在单个事务中封装到DB2和ids表的新一行的insert，要做什么呢？
The module dtd2sql generates a list of CREATE TABLE statements, while xml2sql generates a list of INSERT INTO statements.
模块dtd2s ql生成CREATEtable语句的列表，而xml2s ql生成INSERT into语句的列表。
The module dtd2sql generates a list of CREATE TABLE statements, while xml2sql generates a list of INSERT INTO statements.
模块dtd2s ql生成CREATEtable语句的列表，而xml2s ql生成INSERT into语句的列表。
应用推荐