为了实现这一目的，在数据库中创建一个存储过程。
In order to accomplish this a stored Procedure is created in the Database.
为了实现动态调用，需要创建一个存储过程，它接受这两个参数并通过此用户输入调用挖掘流。
To enable dynamic invocation, you should create a stored procedure that takes two parameters and invokes the mining flow with this user input.
第2课：用存储过程进行装载——创建一个存储过程，以演示用于装载XML文档的两种方法中的第一种方法。
Lesson 2: stored procedure load - Creates a stored procedure to demonstrate the first of two methods for loading XML documents.
使用存储过程作为查询主题输入有一个好处，那就是不需要在数据库中创建不必要的表或视图。
Using a stored procedure as query subject input has the advantage that no unnecessary tables or views are created in the database.
数据建模是指创建抽象的工件以描述如何表示、存储和使用数据的一个过程。
Data modeling is the process of creating abstract artifacts that describe how data is represented, stored, and used.
SQL存储过程是预编译的，并且是在创建时绑定到一个包上的。
SQL stored procedure is pre-compiled and bound to a package at creation time.
首先，创建一个简单的存储过程SP_GET _ LOC，它从表org中返回某个给定部门的位置(步骤1)。
First, let's create a simple stored procedure SP_GET_LOC that returns the location for a given department from the table ORG (step 1).
创建一个SQL存储过程。
可以通过一个存储过程调用来调用数据挖掘，数据挖掘将在数据库中创建一个XML 挖掘模型。
Mining is invoked by a stored procedure call and creates an XML mining model in the database.
在这里，首先需要启动一个新项目，该项目用于创建可部署在SAMPLE数据库内的新存储过程。
Here, you need to start a new project, which can be used to create a new stored procedure that can be deployed inside the SAMPLE database.
因此，SQL存储过程必须为添加的每个块创建一个惟一的路径名。
Therefore, each chunk that you add has to have a unique pathname that is created by the SQL stored procedure.
为了构建这个日志框架，需要数据库管理员帮我们设置存储过程的日志目录并创建一个用户临时表空间。
In order for you to set up the logging framework, you will need help from your database administrator to set up the stored procedure logging directory and a user temporary table space.
其他对象的存储过程也是一样，例如链接会创建一个新的PDOMBinding作为存储已命名节点的一部分的情况。
The storage process is similar for other objects, such as when the linkage creates a new PDOMBinding as part of storing a named node.
在下面的几个段落中，您将看到如何创建一个CognosFrameworkManager项目、定义这两个输入表以及前面创建的存储过程。
In the following paragraphs, see how to create a Cognos Framework Manager project, define the two input tables and the previously created stored procedure.
可以在ServerExplorer中选择一个表、视图或存储过程来创建XAML应用程序。
A table, view, or stored procedure can be selected in Server Explorer to create an XAML application.
在DataDevelopment项目中创建一个新的存储过程。
Create a new stored procedure within a Data Development project.
SQL查询使用存储过程为每行返回数据创建一个xml列表元素，同时传递null作为列以获取值，因为它的值就是它的子元素。
The SQL query USES the stored procedures to create one XML listing element per row of data returned, passing in null as the column to obtain its value from because its value is its subelements.
创建一个文本搜索collection是通过调用SYSPROC . SYSTS_CRTCOL存储过程来实现的。
Creating a text search collection is performed by invoking the SYSPROC.SYSTS_CRTCOL stored procedure.
DB 2提供了一个由系统定义的存储过程，称为SYSINSTALLOBJECTS，它可以创建或删除OPT _ profile表。
DB2 provides a system-defined stored procedure called SYSINSTALLOBJECTS that can create or drop the OPT_PROFILE table.
在导入表和存储过程并调整了数据库对象的元数据后，就可以为此项目创建一个包并将其发布到CognosContentStore。
After importing the tables and the stored procedure and adjusting the meta data for those database objects, you can create a package for the project and publish it to the Cognos Content store.
下面让我们来创建一个多个步骤的场景，从而详细了解一下如何从Perl程序中调用DB2的存储过程。
Let's create a multi-step scenario to see how a DB2 stored procedure is called from a Perl program.
清单11使用out参数prod _ id创建一个具有out参数的存储过程。
Listing 11 USES the out parameter prod_id for creating a stored procedure with the out parameter.
在部署SQLJ存储过程时，将JAR文件写到一个文件中，并执行BINDPACKAGECOPY在目标服务器上创建包。
When deploying SQLJ stored procedures, write the JAR file to a file and execute a BIND package COPY to create the package on the target server.
例如，创建一个名为rawdevsize . sh的脚本作为包装器，它在SQL存储过程中调用rawdevsize程序，如清单6所示。
For example, create a script named rawdevsize.sh as a wrapper that calls the rawdevsize program from within the SQL stored procedure, as shown in Listing 6.
不过，创建模型的调用是一个不具有任何返回值的存储过程。
The call that creates a model is, however, a stored procedure that does not have any return value.
SQL存储过程的创建十分容易，因此，对于每个带有INOUT和OUT参数的存储过程，都可以创建一个包装器存储过程。
It is easy to create SQL stored procedures, so for each stored procedure with INOUT and OUT parameters, you can create a wrapper stored procedure.
要重新绑定存储过程的包，我们需要先删除它，然后再重新创建绑定新REOPT级别的存储过程，或者为这个特定的SQL存储过程重新绑定一个包。
To rebind the package for a stored procedure, drop and recreate it with new REOPT level, or rebind the package for this specific SQL stored procedure.
该过程使用FEM创建一个存储策略，并为之指定一个存储区域列表。
The procedure USES FEM to create a storage policy with an explicit list of storage areas that are assigned to it.
在SYSADMIN数据库中创建一个名为check_dbspace_rd的存储过程，如清单5所示。
Create a stored procedure named check_dbspace_rd in the SYSADMIN database, as shown in Listing 5.
利用包含存储过程作为源的数据库，在IBMCognos管理页面中创建一个IBM Cognos数据源。
An IBM Cognos data source is created with the database containing the stored procedure as a source in the IBM Cognos administration page.
应用推荐