The default command for the SQL editor is autocommit off.
SQL编辑器的默认命令为autocommit off。
Note that autocommit must be off to use a scroll-insensitive cursor.
注意,要使用滚动不敏感型游标,必须关闭自动提交功能。
Definitely do not commit for every row, so watch out for autocommit situations.
千万不要每一行都提交,因此要小心自动提交情况。
The default behavior for the DB2 command line processor (CLP) is autocommit on.
DB 2命令行处理器(CLP)的默认行为是autocommit on。
An example of RMLT is setting an autocommit to false and later committing the connection.
RMLT的一个示例是将autocommit设置为false,稍后再提交连接。
First, you disable AUTOCOMMIT so that changes aren't automatically applied to the database.
首先,禁用autocommit以便更改不会被自动地应用到数据库中。
Note: If you're only going to iterate through a cursor, you can leave the AUTOCOMMIT mode enabled.
注:如果仅通过游标进行循环访问,则可以把AUTOCOMMIT模式保留为启用状态。
Disable autocommit (which is enabled by default in many application environments, such as JDBC).
禁用自动提交(autocommit),在许多应用程序环境中这是默认启动的,比如jdbc。
Thus, to perform positioned update or delete operations, you need to disable the AUTOCOMMIT mode.
因而,要执行定点的更新或删除操作,您必须禁用autocommit模式。
This is possible because you never executed a COMMIT command, and the AUTOCOMMIT mode was disabled.
这是可能的,因为您永远不执行COMMIT命令,并且禁用了AUTOCOMMIT模式。
For example, a select statement is issued with autocommit off and before commit or rollback is issued.
例如,在自动提交完成后,在commit或rollback发出之前,发出一个select语句。
Things to note about this method are the use of the default connection and setting the autocommit mode to false.
对于这个方法,需要注意默认连接的使用,还要将自动提交模式设为false。
Because you're working with AUTOCOMMIT disabled, your new row isn't permanently saved in the bigdog.products table.
由于是在AUTOCOMMIT处于禁用状态的情况下工作,因此新行并未永久地保存到bigdog. products表中。
First, you should turn off autocommit mode so the results of each SQL statement aren't automatically committed to the database.
首先,应当关闭自动提交模式,这样,每条sql语句的结果不会被自动提交给数据库。
In this application, connection conn1 is acquired from datasource, ds, and then the autocommit value of connection conn1 is set to false.
在本应用程序中,连接conn1从数据源ds获得,然后连接conn1的autocommit值被设为false。
By default, the AUTOCOMMIT mode is on, and any data-modification process causes a commit operation to be performed - which, by default, closes any open cursors.
默认情况下,AUTOCOMMIT处于启用状态,并且所有数据修改过程都将导致执行一次提交操作——该操作在默认情况下将关闭所有打开的游标。
Notice in Listing 1 that the autoCommit value is set to true, indicating to the DBMS that the local transaction should be committed after each database statement.
注意,在清单1中,autocommit值设置为true,这将指示DBMS应该在各数据库语句之后提交本地事务。
Notice in Listing 2 that the autoCommit property is set to false, informing the underlying DBMS that the connection will be managed in the code, not the database.
注意,在清单2中,autocommit属性设置为false,这将通知底层DBMS在代码而非数据库中管理连接。
In this technique, you would set the autoCommit property on the connection object to false and manually commit or roll back the connection. Listing 2 illustrates this technique.
在此技巧中,您将Connection对象上的autocommit属性设置为false,并手动提交或回滚连接。
In this technique, you would set the autoCommit property on the connection object to false and manually commit or roll back the connection. Listing 2 illustrates this technique.
在此技巧中,您将Connection对象上的autocommit属性设置为false,并手动提交或回滚连接。
应用推荐