访问计划描述访问路径，这些路径是DB 2优化器为sql语句访问数据而选择的。
Access plan describes the access path that the DB2 optimizer has chosen for accessing data for an SQL statement.
它使来自所有选择语句的数据作为单个流显示到视图。
It makes the data from all the Select statements appear as a single stream to the view.
当您编写访问DB2数据的sql语句时，要确保遵循以下三个编码sQL的准则以获得最佳性能。
When you write SQL statements that access DB2 data, be sure to follow these three guidelines for coding SQL for performance.
目前这个提供程序支持主机变量、模块、ARRAY数据类型、复合语句和可变长度时间戳。
This provider now supports host variables, modules, the ARRAY data type, compound statements, and variable length timestamps.
跟踪连接或语句的元数据信息让我可以跨越请求，针对连接或语句把统计值分组。
Tracking metadata information about connections or statements lets me group statistics across each request for equivalent connections or statements.
在网格中的某台服务器上的网格上下文中运行SQL数据定义语句时，那些语句将被广播到网格中的其他所有服务器。
When you run SQL data definition statements from within a grid context on one server in the grid, those statements are propagated to all other servers in the grid.
DB 2在执行第一条更改表数据的语句时生成一个开始时间列。
DB2 generates the start time column when it executes the first statement that changes the table's data.
下一节模式验证中讨论doctype语句和数据类型化。
I discuss DOCTYPE statements and data typing in the next section, Schema for validation.
您可以执行数据定义语言(DDL)和数据操作语言(dml)语句，并使用该工具来获取和显示结果。
You can execute both data definition language (DDL) and data manipulation language (DML) statements, and obtain and display the results using this tool.
可以使用物理数据模型来生成数据定义语言(ddl)语句，然后可以将这些语句部署到一个数据库服务器上。
A physical data model can be used to generate data definition language (DDL) statements which can then be deployed to a database server.
必要时，检查调试或执行数据流时生成的语句。
If desired, inspect the statements generated by debugging or executing your flow.
这使管理员能够使用熟悉的SQL数据定义语言(DDL)语句来创建存储XML数据的数据库对象。
This enables administrators to use familiar SQL data definition language (DDL) statements to create database objects for persisting their XML data.
您无需编写任何数据库连接语句，因为创建网格数据服务时ogsa - DAI在后台会为您进行相应的数据库连接。
You don't need to write any database connect statements. OGSA-DAI executes the appropriate database connection for you behind the scenes when creating the Grid data Service.
数据定义语言(DDL)语句是不能回滚的语句。
Data definition language (DDL) statements are not statements that can be rolled back.
FORCE：不考虑数据表是否在前端，sql语句总是在后端数据库中执行。
FORCE: Irrespective of whether the tables are present in the front end, the SQL statements are always executed in the back-end database.
如果NOT LOGGED表在执行数据修改语句期间碰到了执行错误，那么对于DB 2来说，就只有一个选择：清空(truncate)该表。
If a NOT LOGGED table encounters an execution error during a data changing statement there is only one choice for DB2: to truncate the table.
当数据可用时，if 语句使您可以从连接进行读取，然后马上处理请求。
The if statement lets you read from the connection when data is available and process the requests immediately.
使用SQLinsert语句将数据添加到表中。
而使用 db2_exec()，成功查询的结果是包含所有请求数据的语句资源；失败的查询将返回false。
With db2_exec(), the result of a successful query is a statement resource that contains all of the requested data; an unsuccessful query returns false.
'REFRESHDEFERRED '子句指出，使用' REFRESH '语句将用数据填充m QT。
The 'REFRESH DEFERRED' clause indicates that use of a 'REFRESH' statement will populate the MQT with data.
在执行数据操作语句（像INSERT/UPDATE/DELETE)之后，使用TRY..CATCH结构或者检查该@@ERROR变量
Use TRY..CATCH construct or check the @@ERROR variable after executing a data manipulation statement (like INSERT/UPDATE/DELETE).
通过这个解决方案，将数据库语句公布为Web服务操作非常简单，只需将sql语句或存储过程拖放到一个Web服务文件夹中。
With this solution, exposing a database statement as Web service operation is as simple as dragging and dropping an SQL statement or stored procedure into a Web service folder.
指定了别名，就可以在目标数据库中用sql语句查询远程表，就像查询任何本地表一样。
Specifying the nickname, the remote table can be queried in SQL statements on the target database like any other local table.
SQL语句分布图显示数据库的动态和静态 SQL语句的分布情况。
SQL statement distribution shows the distribution of dynamic and static SQL statements for a database.
验证数据：通过语句钩子可以在执行语句之前验证参数数据，从而为应用程序级的约束检查和数据验证提供机会。
Validate data: statement hooks let you validate parameter data before statement execution, providing the opportunity to do constraint check and data validation at the application level.
您可以参考清单1中的数据定义语言（DDL）语句，为样例应用程序创建数据库和表。
You can refer to the Data Definition Language (DDL) statements in Listing 1 to create the database and table for the sample application.
“数据表查询向导”对话框可以帮助你构造你自己的查询语句，之后数据表会被新数据更新。
The "DbTable query Wizard" dialog opens to help you construct your query, after which the table is updated with the new data.
数据源语句缓存大小指定每次连接可以缓存的经过准备的jdbc语句的数量。
Data source statement cache size specifies the number of prepared JDBC statements that can be cached per connection.
所有数据，包括动态sql语句、用户输入数据、用户输出数据以及SQLCA中的字符字段，都是基于该代码页进行解释的。
All data, including dynamic SQL statements, user input data, user output data, and character fields in the SQLCA, is interpreted based on this code page.
因此，用于更新统计数据的update语句可能失败并产生SQL 1227n错误消息。
Hence, the update statements to update the statistics can fail with the SQL1227N error message.
应用推荐