You can retrieve table and view data, alter the data, and propagate the updates back to the server.
您可以检索表和视图数据,更改数据,以及将更新传回服务器。
Ask only for what you need: Don't retrieve the entire contents of a table — or the entire contents of many XML documents — if you only need a subset of this information.
只寻找您需要的:如果您只需要该信息的一个子集的话,不要检索一个表的整个内容——或者许多XML文档的整个内容。
You can use the system catalog views to retrieve information about storage management objects such as table Spaces.
可以使用系统编目视图来检索关于表空间之类的存储管理对象的信息。
To retrieve structured type data from a table, there must be some way to convert that type into a single scalar value whose type, in turn, must be based on one of the built-in DB2 data types.
为了从表中检索结构化类型数据,必须有一些将类型转换成一个标量值,换句话说,这些值的类型必须基于某种内置的DB2 数据类型。
Table 1 Outlines the ways to retrieve an error from the error stack.
表1略述了从错误栈检索错误的方法。
The simplest way to do this is through an SQL function called XMLTABLE, which concisely describes how to retrieve XML data in relational (or table) format.
实现这个目的的最简单方法就是使用XMLTABLE的sql函数,该函数可以准确地描述如何以关系(或表)格式检索XML数据。
Without knowing unique attributes of the changed users, it is impossible to construct SQL query statement that retrieve only the changed data from the users table.
在不知道已改变用户的唯一属性的情况下,构造一个SQL声明去users表中重新获取已经改变的数据是可能的。
The DW.ASSIGNED Query Table (Figure 5) is needed to retrieve tasks that are assigned to the user, but is never completed in case of an error.
ASSIGNED 查询表(图5)需要检索分配给用户的任务,但是,如果有错误就不能完成。
DB2 transparently accesses the history table to retrieve the correct information.
DB 2透明地访问历史表,检索正确的信息。
Retrieve specific columns from a relational database table.
从关系数据库表中检索特定的列。
Retrieve specific rows from a relational database table.
从关系数据库表中检索特定的行。
Retrieve rows from a relational database table.
从关系数据库表中检索行。
This functionality was exposed using the Retrieve Data menu option on the table and view nodes in the IBM Explorer tree.
此功能使用IBMexplorer树中的表和视图节点上的RetrieveData菜单选项公开。
Table 2 describes the parameters, such as identifying an application, Blogs, that can be used to allow the application to retrieve the filtered content wanted.
表2描述了参数,例如确定一个应用程序Blogs,可以用来允许应用程序检索所需的过滤后的内容。
The query uses a WHERE clause to filter the contents of the weather.bylocation table and retrieve a weather forecast for the specified zip code.
该查询使用WHERE 子句来筛选weather.bylocation表的内容并检索指定邮政编码的天气预报。
This statement will retrieve only those CUST_INFO documents from CUSTOMER table which are validated against any of the registered schemas.
这个语句仅从customer表获取根据已注册模式验证的CUST_INFO文档。
We selected our database, named rss_agg and wrote a very simple select statement to retrieve all records from the feeds table.
我们选择了数据库,命名为rss_agg,并编写了一条十分简单的select语句从feeds表中检索所有记录。
Instead, you should call the TSQLDataSet.FieldDefs.Update method, which will only retrieve the metadata for the field definitions, and not the actual record data for the selected table itself.
您应该调用TSQLDataSet. FieldDefs . Update方法,该方法只为字段定义检索元数据,没有为选定的表本身检索实际记录数据。
You can also use the system catalog views to retrieve information about NOT NULL, unique, primary key, foreign key, and table check constraints. For example.
也可以使用系统编目视图来检索关于NOT NULL、惟一、主键、外键和表检查约束的信息。
The JDBC adapter uses the object_key as an index into the Customer table to retrieve the changed row.
JDBC适配器使用 object_key作为对客户表的索引,以检索更改的行。
In a similar vein, with an XML table, you can apply YQL filters to any XML document, combining it with XPath to retrieve specific node collections.
同样地,您可以使用一个xml表向任何xml文档应用YQL过滤器,结合使用XPath检索特定的节点集。
The next example shows how you can retrieve the value for the aggregate function max for the salary column from the EMPLOYEE table
下面这个例子展示了如何为一个聚合函数max从EMPLOYEE 表中检索salary的值
TO retrieve a single incident report from the CROTON_DATA table requires just an XML query. Listing 4 illustrates an example query.
要从croton_data表中检索单个事件报告,只需一个XML查询即可。
This gives us 23 tables and a 24-table join to retrieve a DICOMData object.
这会产生23个表,而且检索一个DICOMData对象要连接 24 个表。
The first line is an SQL clause specifying that you only want to retrieve information in the "name" column of the "clients" table.
第一行是一个SQL子句,指定仅检索 "clients"表 "name"列中的信息。
A SQL query to retrieve a user from a users table might look like Listing 1.
从users表中检索用户的SQL查询可能类似于清单1。
The operations such as create, update, retrieve, and delete (CRUD) are facilitated through corresponding functions in the Groovy handler as shown in table 3.
创建、更新、检索和删除(CRUD)等操作通过Groovy处理程序中的相应函数得以简化,如表3 所示。
The program has one performance flaw-i retrieve the string entry in the associated string table by value rather than pointer.
该程序有一个性能缺陷—我是按值而不是按指针在关联的字符串表中检索字符串条目的。
I store the generated words in a separate table so that I can retrieve and display them at every generation.
我将生成的单词存储在一个单独的表中,这样我就可以在每一次衍生中获取并显示它们。
Now, suppose we want to retrieve only one address element (say, city) from the CLIENTS table.
现在,假设我们想从clients表中检索一个地址元素(比如说,城市)。
应用推荐