If you already know SQL, then it will be easy for you to query a CMIS repository.
如果您已经了解SQL，那么对您来说查询CM IS知识库将非常容易。
This ensures high availability for your SQL management repository.
这就确保了SQL管理存储库的高可用性。
The scenario in this article creates the SQL management repository in the same database that the application uses in production.
本文中的场景在生产使用的应用程序的相同数据库中创建了SQL管理存储库。
Because this location is incorrect when the capture file is uploaded to the SQL management repository, this removes the property that points to the workspace.
因为当捕获文件上载到SQL管理存储库时该位置不正确，所以这会删除指向工作区的属性。
The first part defines how the data is retrieved from the data repository, which includes the location of the data source, the SQL queries, and the relationship of the queries.
第一部分定义如何从数据仓库中检索数据，包括数据源的位置、SQL查询以及查询的关系。
For example, if you choose not to access the repository using static SQL, you need to grant privileges to the repository tables themselves.
例如，如果您选择不使用静态SQL访问存储库，就需要将权限授予存储库表格本身。
The capture file with the new SQL is saved in the SQL management repository.
带有新sql的捕获文件存储在SQL管理存储库中。
You can then choose to upload to the SQL management repository when you are ready for deployment.
然后在准备部署时可以选择将其上载到SQL管理存储库。
This section describes how to look at all the incrementally collected SQL in the repository and how to set up the configuration and bind properties required for the newly captured SQL.
本部分介绍如何查看存储库中增量收集的SQL，以及如何为新捕获的SQL设置配置并绑定所需的属性。
You have also created the SQL management repository that you want to use to store your captured SQL and runtime properties.
您还创建了要用于存储捕获的SQL和运行时属性的SQL管理存储库。
You have the option to save the newly captured SQL directly in the SQL management repository runtime group. Follow these steps
可以选择直接在SQL管理存储库的运行时组中存储新捕获的 SQL。
Of course you need the basic it skills of data design and architecture, database administration, Structured Query Language (SQL) scripting, data repository mapping, and business domain knowledge.
当然，您需要数据设计和架构、数据库管理、结构化查询语言(Structured Query Language,SQL)、脚本、数据存储库映射和业务领域知识等基本IT技能。
Upload application and properties to the SQL management repository.
将应用程序和属性上载到SQL管理存储库。
That means it would be as simple as forming a SQL query, such as SELECT * FROM DOCUMENT, to get a list of documents in the repository.
这意味着它将和形成一个SQL查询一样简单，例如，使用 SELECT *FROMDOCUMENT 语句获取知识库中的文档清单。
Following are some of the advantages of using an SQL management repository.
下面是使用SQL管理存储库的一些优势。
This database is used as the metadata repository for the InfoSphere Warehouse applications where the metadata related to common configurations, SQL Warehousing, and Cubing Services are stored.
该数据库用作InfoSphereWarehouse应用程序的元数据存储库，其中存储通用配置、SQLWarehousing和CubingServices相关的元数据。
This XML schema will be registered in DB2's internal repository under the SQL schema user1 and the XML schema mysample.
这个XML模式将被注册到SQL 模式user1和 XML 模式 mysample下的DB2内部存储库中。
Setting up the SQL management repository.
构建SQL管理存储库。
PropertiesGroupId specifies the runtime group ID in an SQL management repository to use when retrieving data or storing data to an SQL management repository.
propertiesGroupId指定在检索数据或将数据存储到SQL管理存储库时要使用的SQL管理存储库的运行时组id。
Create a blank SQL database (s) for the Controller application repository (for financial data).
为Contoller应用程序存储库(用于财务数据)创建一个空s QL数据库。
The captured SQL and associated runtime properties are now uploaded to the repository.
现在捕获的SQL及其相关运行时属性都上载到了存储库。
You can create the SQL management repository along with your transaction database used in production.
您可以使用生产中的事务数据库创建SQL管理存储库。
You can now use the change report feature to see the differences in the captured file with the new SQL compared to the file already in the repository.
现在可使用更改报告功能查看带有新SQL的捕获文件与存储库中已存在文件之间的不同。
The mapping repository is also accessed by the query-translate module, which generate SQL queries from XML queries.
查询转换模块也是通过访问映射知识库的信息来完成XML查询到SQL查询的转换。
To optionally use static SQL when accessing the repository, use the bind command to create the database packages, as shown in Listing 2.
访问存储库时要可选地使用静态SQL，请使用bind命令创建数据库包，如清单2所示。
Problem: Business Events V6.2.1 is installed with Microsoft SQL Server database as the repository, and you see an unsupported database warning, as shown in Figure 1.
问题：在安装BusinessEvents v6.2.1时使用MicrosoftSQLServer数据库作为存储库，看到不支持的数据库警告，见图1。
For convenience,.sql scripts are also provided to enable you to remove the tables that were created when a configuration repository is set up.
为了方便，还提供了删除在设置配置存储库时创建的表的.sql脚本。
Merge the new SQL with the already captured SQL in the repository using the Optim Common Repositories perspective by following these steps.
使用OptimCommonRepositories透视图将新SQL与已捕获的SQL合并起来，操作步骤如下所示。
Issue the following SQL to get the object id, the relational id, the schema location used inside of XML schema Repository, and the content of XML schema.
执行以下SQL来获取对象id、关系ID、在XMLSchemaRepository中使用的模式位置，以及XML Schema的内容。
Repository \ websphere \ jars: This directory contains the websphere embedded JDBC driver for Microsoft SQL 2000 database server.
repository \websphere \jars：这个目录包含用于MicrosoftSQL 2000数据库服务器的websphere嵌入式JDBC驱动程序。
应用推荐