本教程通过一系列简单的例子,阐释如何用标准SQLSELECT语句检索IBMDB2数据库中的数据。
Using a series of simple examples, this tutorial illustrates how to retrieve data from an IBM DB2 database with standard SQL SELECT statements.
在DB 2中,最后一个失败的sql语句的错误字符串可以通过使用GETDIAGNOSTICS语句检索,参见表4。
On DB2, the error string of the latest failed SQL statement can be retrieved using the GET DIAGNOSTICS statement, as shown in Table 4.
下面的sql语句将检索关于由供应商id介于某个范围的供应商所供应的商品的信息。
The following SQL statement will retrieve information about the items supplied by suppliers with the supplier IDs in a certain range.
传统数据库系统可以使用一系列的sql语句,通过某种形式的专有客户端软件或API来执行数据检索和更新功能。
Traditional database systems allow you to perform data retrieval and update functions using a series of SQL statements that are executed through some form of proprietary client software or API.
然后它会使用枚举的成员构造一个mdx语句,以检索带有请求的度量的嵌套成员。
It will then use the enumerated members to construct an MDX statement in order to retrieve the nested members with the measures requested.
可以使用一个定制SQL语句来检索此信息,如清单12 所示。
You could use a custom SQL statement to retrieve the information, as shown in Listing 12.
第一条规则是始终在每条 SQLSELECT语句的SELECT 列表中只提供 确实需要检索的那些列 。
The first rule is to always provide only the exact columns that you need to retrieve in the SELECT-list of each SQL SELECT statement.
要从过程生成用户错误,可以使用SQLERROR变量检索一个实际的错误字符串,该错误字符串使语句无法作用于调用应用程序,如清单16所示。
To generate user errors from procedures, you can use the SQLERROR variable to return an actual error string that caused the statement to fail to the calling application, as shown in Listing 16.
必须检索和处理由sql语句生成的结果。
The results generated from the SQL statements have to be retrieved and processed.
如果您是没有XML经验的SQL程序员,那么不必担心,因为用简单的sql语句就能够检索xml列中存储的数据内容。
If you're an SQL programmer with no prior XML experience, you'll be relieved to learn that a simple SQL statement will enable you to retrieve the contents of data stored in XML columns.
一种方法是开发多个基于Blox的JSP,每个jsp连接到一个不同的数据源,并通过发出特定于这些数据源的sql语句来检索正确的数据。
One way involves developing multiple Blox-based JSPs, each of which would connect to a different data source and issue SQL statements specific to those sources to retrieve the correct data.
当FETCH游标语句失败并且没有找到另一个要检索的行,SQLSUCCESS的值被设置为 0 并且WHILE LOOP结束。
When the FETCH cursor statement fails and does not find another row to retrieve, the value of SQLSUCCESS is set to 0 and the WHILE LOOP ends.
在XQuery程序中使用以下xpath语句从atom提要检索可疑评论。
You retrieve the questionable comments from the Atom feed with the following XPath statement in the XQuery program.
mi_get _id:检索语句id或会话id。
Mi_get_id : Retrieve either the statement id or the session id.
确定从Informix选择的行和列,并执行一条SQLselect语句,以检索数据。
Identify the rows and columns to select from Informix and execute an SQL select to retrieve the data.
GETDIAGNOSTICS语句几乎支持对SQLCA区域的所有字段的检索,该区域由用于每条sql语句的数据库来填充。
GET DIAGNOSTICS statement supports retrieval of almost any fields of SQLCA area, populated by the database for each SQL statement.
这个上下文然后被追加到在检索到的RSS中找到的每个语句中。
This context is then appended to every statement found in the retrieved RSS.
该面板显示PDI从选定性能数据中检索数据所用的具体的sql语句。
This panel shows the exact SQL statement PDI will use to retrieve data from the performance data selected.
最后,我们将检索sql语句的结果并关闭数据库连接。
Finally, we retrieve the results of our SQL statement and close the connection to the database.
典型的情况是,检索的字段都与列名相匹配,并且使用SQL的LIKE语句。
The search fields typically match columns that the SQL query will use in LIKE clauses.
这个语句不需要任何where子句,因为我们希望检索所有的行。
This statement needs no WHERE clause, because we want to retrieve all the rows.
我们选择了数据库,命名为rss_agg,并编写了一条十分简单的select语句从feeds表中检索所有记录。
We selected our database, named rss_agg and wrote a very simple select statement to retrieve all records from the feeds table.
因此,update语句无法找到具有ROWCHANGETOKEN的行,这些行是在发生REORG之前检索得到的。
Thus the UPDATE statement fails to find the row with the row CHANGE TOKEN that was retrieved before the REORG occurred.
如果只能检索包含出生日期元素的交易,必须在where语句中使用exists函数,如清单10所示。
If it is necessary to retrieve only those transactions that specify elements for birth date, then the exists function is added to the where statement, as in Listing 10.
检索客户id和更新订单被合成一条语句。
Retrieving the customer id and updating the order has been folded into one statement.
SELECT语句中的WHERE子句指定具体检索哪些行的搜索条件。
The WHERE clause in a SELECT statement specifies the search conditions for exactly which rows are retrieved.
SQL语句通常用于完成一些数据库的操作任务,比如在数据库中更新数据,或者从数据库中检索数据。
SQL statements are usually used to complete some tasks of database operations, such as updating the database data or from the database retrieval of data.
跨语言信息检索中,输入的查询语句往往是一系列关键词组合,而不是一个完整的句子。
In the cross language information retrieval, the query input is often a combination of keywords, not a complete sentence.
跨语言信息检索中,输入的查询语句往往是一系列关键词组合,而不是一个完整的句子。
In the cross language information retrieval, the query input is often a combination of keywords, not a complete sentence.
应用推荐