IDS does not implicitly start a new transaction for the EXECUTE statement. So, you must start a transaction explicitly.
IDS不会隐式地为execute语句开始一个新事务。
The user executing the statement must have the appropriate privileges to execute that statement at run-time, either because they were explicitly granted them or possess them through group membership.
执行语句的用户必须具有适当的特权,才能在运行时执行语句,特权可以是明确授予他们的,也可以是通过组成员关系授予的。
You can refer to the multiple schemas in a single SQL statement and it will execute within the same connection (no open is required).
您可以在单个sql语句中引用多个模式,该语句将在同一个连接中执行(不需要打开)。
Using this predicate, the container will execute the SQL statement in the sample below.
使用这个谓词,容器将执行下面代码样本中的SQL语句。
The naive approach USES a cursor to scan the table and execute a positioned update statement for each row.
初级的方法是使用一个游标对表进行扫描,并为每一行执行一个定位的更新语句。
It generates the code required to execute each SQL statement annotated for each method in the interface.
它生成的代码用来执行针对接口中每个方法进行注释的每个sql语句。
So when you want to execute a statement many times, prepared statement is a better option.
所以,如果想多次执行一条语句,那么预置语句是更好的选择。
You can execute the statement to create this view in a DB2 command line or other query tool.
您可以使用DB 2命令行或其他查询工具执行这些语句来创建视图。
The article described the mission statement and an organization to execute the mission statement along with sample activities to describe the scope and role of the COE.
本文描述了任务陈述和执行任务陈述的组织,以及用于描述COE的范围和作用的示例活动。
When you execute a prepared statement, IDS now detects changes to underlying objects and re-prepares (re-compiles) the statement if needed.
当执行预编译语句时,IDS检测底层对象的变化,必要时重新准备(重新编译)语句。
To execute the SQL statement, simply click the running man icon as shown in Figure 9.
要执行这个sql语句,只要单击如图9所示的奔跑男子图标就可以了。
Now let's see how to execute an SQL statement which is unknown at the time the application is written and has parameter markers or placeholders; that is, a truly dynamic SQL statement.
现在让我们来看一下如何执行在编写应用程序时还不确定并且具有参数标记(即占位符)的SQL语句 ——即真正的动态 SQL 语句。
So if an access plan is reused, a database server requires less CPU resources to execute the corresponding SQL statement repeatedly.
因此,如果一个访问计划被重用,则数据库服务器重复执行相应sql语句所需的CPU资源将减少。
In the first session, execute the UPDATE statement shown in Listing 16, which places an exclusive lock on the row with department number B01.
在第一个会话中,执行清单16中的update语句,它对部门号为B01的部门行设置独占锁。
This provides the ability to simply check the syntax or test execute the SQL statement provided in the view definition.
这使您可以选中视图定义中提供的语法或测试执行sql语句。
The SQL Maps framework will create a PreparedStatement instance, set any parameters using the provided parameter object, execute the statement, and build a result object from the ResultSet.
SQLMaps框架将创建一个PreparedStatement实例,使用所提供的参数对象设置所有参数、执行语句以及从ResultSet中构建一个结果对象。
For example, the code to create a connection, prepare and execute a statement looks very similar in olap4j and JDBC.
比如说,olap4 j里创建连接、准备和执行语句的代码看起来和JDBC里的非常像。
Execute a statement to turn on diagnostic helpstats for the remainder of the session (" diagnostic helpstats on for session ").
执行语句来为会话其余部分打开诊断helpstats(“诊断helpstats用于会话”)。
A while loop within bash allows you to execute a statement a given number of times, or until a certain condition is met.
bash中的while循环可以重复执行语句一定的次数,或者一直执行到满足某一条件为止。
This same technique might be used to execute a DROP TABLE statement or to execute a system stored procedure that created a new user account and added that user to the sysadmin role.
这一技术可能会被用来执行DROPtable语句,或执行创建新用户帐户并将该用户添加到sysadmin角色的系统存储过程。
pureQuery is able to execute a SQL statement on this existing result set, filtering only the products that have the status of bestseller.
pureQuery可以在这个已有的结果集上执行SQL语句,只过滤出状态为畅销品的产品。
From the BSD command line, log into mySQL and execute the statement in Listing 5 to create a database.
在BSD命令行中,登录到mySQL并执行清单5的语句来创建数据库。
From a tool such as DB2 SPUFI, execute the SQL statement shown in Listing 4.
从一个诸如db2spufi之类的工具,执行清单4所示的sql语句。
This will execute the SQL statement and the result set will be displayed in the Data View of the Eclipse IDE (see Figure 27).
这将执行该sql语句,并在EclipseIDE的DataView中显示结果集(见图27)。
Without the statement concentrator feature, prior releases of DB2 would treat each statement in the above example as unique, and would compile and execute each statement separately.
由于没有语句集中器,DB2之前的版本需要单独处理上面例子中的每个语句,单独编译和执行每个语句。
For batch updates, a collection parameter is used vertically to execute an SQL statement more than once, with different parameter values each time.
对于批量更新,需要使用一个集合参数多次执行一条sql语句,每次执行时使用不同的参数值。
执行映射的语句。
This dynamically prepared statement can be executed using the SQL command execute.
可以使用SQL命令EXECUTE来执行这个动态预备语句。
Sure enough, when you try to execute the SQL statement, you get an exception telling you that the connection is a read-only connection.
毫无疑问,在试图执行sql语句时,您会得到一个异常,告诉您该连接是一个只读连接。
Sure enough, when you try to execute the SQL statement, you get an exception telling you that the connection is a read-only connection.
毫无疑问,在试图执行sql语句时,您会得到一个异常,告诉您该连接是一个只读连接。
应用推荐