The column value separators can be changed from the defaults in the LOAD DATA statement.
在LOADdata语句中可以修改列值分隔符的缺省值。
These data statement method could efficiently draw information from the first-hand materials, and supply more evidence to the result interpretation.
几种数据表达方法,能有效地提取原始资料所含有的信息,为成果解释提供更多的依据。
Condensed balance sheet and income statement data for Glassgow Corporation are presented here.
这里列出了Glassgow 公司的简明资产负债表和损益表的数据。
In addition, figures published in the 2006 article were inconsistent with the original data, the statement said.
此外,这份声明亦表示,2006年《科学》论文中的图表与原始数据存在相互矛盾。
The commit statement restores the session data to the previous commit or rollback statement.
提交语句会将会话数据恢复为之前的提交或回滚语句。
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.
验证数据:通过语句钩子可以在执行语句之前验证参数数据,从而为应用程序级的约束检查和数据验证提供机会。
Data sources connection pool and prepared statement cache.
数据源连接池和事先声明的高速缓存。
The direct statement execution method includes additional logic to strip the data after the where clause in the SQL statement.
直接的语句执行方法包括:sql语句中在where子句之后剥离数据的附加逻辑。
In conversions to DB2 9.1, the ALTER TABLE statement with data compression is supported, and limited support is provided for CREATE TABLE statement.
在到DB 2 9.1的转换中,包含数据压缩的ALTERtable语句是受支持的,CREATE table语句也受到有限的支持。
The SQL baseline must be captured during the test and not after, as done for the reports on aggregated data, because a DB2 statement event monitor is started to capture the data.
必须在测试期间捕捉SQL基线,而不是像聚合数据报告那样在测试之后捕捉,这是因为要启动db2语句事件监视器来捕捉数据。
Another query against the summary table returns no data, but after the REFRESH table statement executes this time, the query runs successfully.
再次查询总结表,又是没有返回数据,但是当执行了REFRESHtable语句之后,查询得以成功运行。
Access plan describes the access path that the DB2 optimizer has chosen for accessing data for an SQL statement.
访问计划描述访问路径,这些路径是DB 2优化器为sql语句访问数据而选择的。
With a federated database, you can use a single SQL statement that joins data from multiple data sources, including the federated database itself.
凭借联邦数据库,您可以使用单独一条sql语句连接来自多个数据源的数据,包括联邦数据库本身。
As described in the value statement, data federation can greatly improve delivery time when integrating various sources.
正如价值主张中提到的,数据联合可以大幅度改进集成各种源时的交付时间。
Data source statement cache size specifies the number of prepared JDBC statements that can be cached per connection.
数据源语句缓存大小指定每次连接可以缓存的经过准备的jdbc语句的数量。
DB2 UDB provides several tools that can be used to monitor database server activities, or to analyze how an SQL statement accesses data; each serves a different purpose.
DB 2UDB提供了多个工具,可以用于监控数据库服务器的活动,或分析sql语句如何访问数据;每个工具都服务于不同的目的。
Here's how to configure a data group called SQL that USES two predefined data views to see SQL statement throughput and to sort overflows.
下面介绍如何配置一个名为SQL的数据组,这个数据组使用两个预定义数据视图来查看sql语句吞吐量和对溢出情况进行排序。
ALWAYS santitize user-submitted data before using it to build an SQL statement.
在构建SQL语句之前,一定要检查用户提交的数据。
The FROM statement describes where to grab data.
FROM 语句描述了获取数据的位置。
The data source statement cache size can be tuned using a few different methods.
可以使用一些不同的方法来调优数据库语句缓存大小。
Briefly, an access plan is the set of steps that DB2 USES to execute a SQL statement and access data.
简单地说,访问计划是DB2用来执行sql语句和访问数据的一组步骤。
Because the archive has been created with the same schema as the active data, the same SQL statement from the previous section can be used here to fetch the order amounts.
由于创建归档数据的模式与活动数据是相同的,因此上一节中的sql语句也同样可以用来获取订单数量。
This statement loads the data from the table and changes the value of the name column in the first row to a new value.
该语句从表中加载数据并将第一行中的名称栏的值改为一个新值。
You can use the PASSTHRU session to directly send the create table statement to the data source and create a nickname for this new table.
您可以使用PASSTHRU会话直接将CREATEtable语句发送到数据源,并为这个新表创建一个昵称。
The federated server communicates a remote request for data to the remote relational data source through an SQL statement in the native SQL dialect of the data source.
联邦服务器通过数据源本地SQL方言中的 SQL语句将对数据的远程请求发送到远程关系数据源。
When SACR is enabled, DB2 chooses a coordinator for the transaction based on the data location of the first statement.
在启用SACR时,DB 2基于第一条语句的位置选择了一个事务协调者。
Listing 5 shows the DB2 data returned by the above SQL statement.
清单5展示上面sql语句返回的DB 2数据。
Or you can access the data using an expression language statement.
或者,也可以使用表达式语言语句访问此数据。
In this case, clear the login data with the DROP REMOTE SERVER statement and recreate the login data.
在这种情况下,使用DROPREMOTEserver语句清除登录数据,然后重新创建登录数据。
As this example shows, writing data is easy with the print statement.
正如这个示例演示的,用print语句写入数据很容易。
应用推荐