Getting set up for SQL data binding.
设置SQL数据绑定。
SQL data binding might be a new term, but it's a pretty simple concept.
SQL数据绑定也许是一个新的术语,概念其实非常简单。
With Castor and SQL data binding, you can avoid most of that complexity.
使用Castor和SQL数据绑定可以避免大部分复杂性。
In this example, all XML data is converted to traditional SQL data types.
在这个例子中,所有XML数据被转换成传统的SQL数据类型。
The table that is returned can contain columns of any SQL data type, including XML.
返回的表可以包含任何SQL数据类型的列,包括XML。
You can change the default generator that is associated with a SQL data type.
您可以更改与某一SQL数据类型关联的默认生成器。
By contrast, indexes on traditional SQL data always involve the entire column's content.
与此相反,传统SQL数据上的索引总是涉及整个列的内容。
Users can freely mix and match storage of traditional SQL data and XML in a single table.
用户可以在一个表中自由地混合存储传统SQL数据和XML数据。
The usage of a temporary table limits tracing to procedures of the class MODIFIES SQL DATA.
临时表的使用限制了对属于MODIFIESSQL data类别的过程的跟踪。
This customized data view is added to the SQL data Group you created in the previous section.
我们将这个自定义数据视图添加到在上一节中创建的SQL数据组中。
A prime example is physical data models that directly manipulate SQL data Definition Language.
一个很好的例子就是直接操作SQL数据定义语言的物理数据模型。
The specification for browser-based SQL data is still in flux, with its specifics still being ironed out.
基于浏览器的SQL数据的规范仍然在不断演变,具体细节仍然在整理当中。
To efficiently manage traditional SQL data types and XML data, DB2 includes two distinct storage mechanisms.
为了高效地管理传统SQL数据类型和XML 数据,DB2包含两种不同的存储机制。
However, XMLTable also includes clauses to map the target XML data into result set columns of SQL data types.
然而,XMLTable还包括一些子句,用于将目标XML数据映射到SQL数据类型的结果集列。
CARPOOL table contains columns based on both SQL data types and one column based on the new DB2 XML data type.
carpool表既包含基于SQL数据类型的列,又包含一个基于新的DB 2XML数据类型的列。
As a result, users can create a single database object that manages both "traditional" SQL data and XML documents.
因此,用户可以用一个数据库对象同时管理“传统的”SQL数据和XML文档。
Look at the simplest SQL data binding task: mapping an object that doesn't refer to any other objects to a single table.
最简单的SQL数据绑定任务:把没有引用其他任何对象的对象映射到一个表。
It then enables you to build the extract and load process, using SQL data flows or your own command and control functions.
它还支持使用SQL数据流或您自己的命令和控制函数构建提取和装载过程。
The current SQL Data Services (SDS), which became available last March, provides a lightweight and limited set of features.
去年三月发布的SQL DataService (SDS)只提供了轻量的,有限的功能。
The data type of a parameter can be set using the data type style property, which can be set to SQL data type, LIKE or REFERENCES.
参数的数据类型可以使用datatypestyle属性设置,该属性可以被设置为SQL data type、LIKE或REFERENCES。
SQL data binding takes a familiar API (assuming you've read the previous articles in this series) and applies it all to SQL data stores.
SQL数据绑定把一种熟悉的API(假设您已经阅读过本系列前面的文章)用于SQL数据存储。
Learn how SQL data binding can help you out, save you effort, and ultimately improve the quality of your work and the applications you develop.
SQL数据绑定可以帮助您提高效率,降低开发周期,最终提高您的工作质量以及所开发应用程序的质量。
However, that doesn't mean you should avoid it, because SQL data binding and JDO (from any vendor) can make your programming life a lot easier.
但是,这并不意味要避免使用它,因为SQL数据绑定和JDO(无论哪个厂商)都可以简化您的编程工作。
Add ORDER by Clause dialog box enables you to further define a SELECT statement for a SQL data source by specifying how the results are sorted.
“添加orderby子句”对话框可以通过指定结果的排序方式,进一步为SQL数据源定义SELECT语句。
The output from the function can then be used as input to another function taking XML arguments, or it can be cast to an equivalent SQL data type.
然后,可以使用函数的输出作为另一个接受XML参数的函数的输入,也可以把它转换为等效的SQL数据类型。
This enables administrators to use familiar SQL data definition language (DDL) statements to create database objects for persisting their XML data.
这使管理员能够使用熟悉的SQL数据定义语言(DDL)语句来创建存储XML数据的数据库对象。
This is the most fundamental operation you'll perform in SQL data binding, and all the more advanced features turn out to be variations on this theme.
这是SQL数据绑定中最基本的操作,其他更高级的功能都是由此演变而来。
In SQL data binding, though, this attribute lets Castor know the field that uniquely defines an object; in this case, that's the id field of an author.
但是在SQL数据绑定中,该属性让Castor知道哪个字段惟一定义了一个对象;该例中是作者的id字段。
Specifications for the representation of SQL data (specifically rows and tables of rows, as well as views and query results) in XML form, and vice versa.
SQL数据(具体而言就是行和表,以及视图和查询结果)以XML形式表示(或者相反)的规范。
Note that Comments and Contactinfo are based on the new DB2 XML data type, while all other columns in the tables are based on traditional SQL data types.
注意Comments和Contactinfo都基于新的DB 2XML数据类型,而表中的所有其他列都基于传统的SQL数据类型。
应用推荐