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 数据类型。
Retrieve the item's name, price and description from the item table.
从ite m表检索产品的名称、价格和描述。
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 Item Type Definition from Hash table.
从散列表中检索项目类型的定义。
Retrieve specific rows from a relational database table.
从关系数据库表中检索特定的行。
Retrieve specific columns 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菜单选项公开。
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表中检索所有记录。
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作为对客户表的索引,以检索更改的行。
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 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表中检索一个地址元素(比如说,城市)。
If you are connected to one partition and wish to retrieve the effective Settings for another partition, you must first connect to the new partition before invoking the table function.
如果您连接了一个分区并希望检索另一分区的有效设置,就必须在调用该表函数之前,首先连接这个新分区。
The current strategy for maximizing performance and convenience is to retrieve metadata for a particular table the first time an instance of the class that maps to that table is instantiated.
为了使性能最大化和更加便利,目前的策略是从某一个表中提出元数据,先把一个类的实例映射到那个表上,用来初始化。
应用推荐