Select Data Source (Manually build a SQL query), give the query a name, and click OK.
选择Data Source (ManuallybuildaSQLquery),指定查询名称并单击ok。
When you select a menu item, the corresponding target is invoked, and the source data is transferred to it.
当您选择一个菜单项时,相应的目标就会被激活,而源数据就会传递给它了。
It USES an additional source column on the SELECT clause in each UNION ALL view to indicate the source of the data.
它在每个NIONALL视图中的select子句上使用一个附加的源列表明数据的来源。
With the DECLARE cursor command, a cursor is defined that reads all data of the source table SALES using a trivial SELECT statement.
使用DECLARECURSOR命令定义一个游标,它使用select语句读取源表sales的所有数据。
Pull down the data type URI (URL) combo box, and select the same data type that you defined in the source portlet.
拉下DataTypeURI (url)组合框,选择与您在这个源portlet中相同的数据类型。
TS (Trace Selections) produces a message each time a stylesheet directive performs a select operation to retrieve data from the source document.
TS(跟踪选择,Trace Selection),每当样式表伪指令执行select操作以从源文档检索数据时就生成一条消息。
Next, in the Target the Data Source frame, select a target server for the data source.
接着,在TargettheData Source框架中,为该数据源选择目标服务器。
The IBM data Movement Tool produces a table name.tables file that states which data to extract from the source database by specifying a SELECT query per database table.
IBMDataMovementTool会生成一个表名。tables文件,其中为每一个数据库表指定一条select语句,从而指明了需要从源数据库提取哪些数据。
Give the query a name, "Query1" is used in this example, and select the data source you created earlier (for example, Tax1120DataSource).
为查询指定一个名称,本例中命名为“Query1”,并选择前面创建的数据源(比如Tax1120DataSource)。
Select the Add button next to the Data source defined in the JDBC provider selected above table.
单击在上面所选JDBC提供者中定义的数据源旁边的Add按钮。
The latter is non-transactional (select non-transactional data source under the WebSphere Application Server data source properties link in the admin console).
后者是非事务型的(在管理控制台之下的WebSphereApplicationServer数据源属性链接之下选择Non -transactionaldata source)。
This wizard (as shown in Figure 2) allows you to select the connection to work with and the data objects to be included in the data source.
该向导(如图2所示)允许您选择要使用的连接和要包含在数据源中的数据对象。
The information in both rows provides enough detail to generate a well formed SQL select statement, which will be executed against the nodes specified data source.
两个行中包含的信息为生成完整的SQL选择语句提供了足够的细节,该语句将对指定数据源的节点执行。
Select a scope for the data source (Figure 17).
选择该数据源的范围(图17)。
This wizard allows you to select the connection to work with and the data objects that the data source is created for.
此向导允许选择要使用的连接和为其创建数据源的数据对象。
Select the Alias used for the data source being tested.
选择测试的数据源所用的别名。
Select the registered ODBC DSN (data source name) from the select box.
从选择框中选择已注册的ODBCDSN(数据源名称)。
In the wizard that is displayed, select the connection, the data objects, and the columns to be used for the data source.
在显示的向导中,选择将用于数据源的连接、数据对象和列。
Select the SAP BW data source containing the data required, and click ‘OK’.
选择包含所需数据的SAPBW数据源,然后单击 OK。
For stored procedures, you can map the input and output parameters of the stored procedure to the data set source columns as defined in the select command.
对于存储过程,您可以将该存储过程的的输入和输出参数映射到select命令中所定义的数据集源列。
Select the Oracle provider we just created, and then add a data source with the Settings shown below.
选择我们刚刚创建的Oracle提供者,然后用如以下所示的设置添加一个数据源。
On the "Select a data source" page, select DWESAMP and clear the Run database query subject wizard check box.
在 “Selectadata source”页面上,选择DWESAMP,并取消对选择Rundatabasequerysubjectwizard复选框。
Together information contained in both rows provides enough detail to generate a well formed SQL select statement, which will be executed against the nodes specified data source.
加在一起,两个行中包含的信息为生成完整的SQLselect语句提供了足够的细节,该语句将对指定数据源的节点执行。
Each data source is then read by a simple SQL SELECT statement, and the join is completed within the InfoSphere DataStage process.
只通过简单的SQLselect语句对每个数据源进行读取,并且在InfoSphereDataStage流程之内完成连接。
Select the appropriate Cognos data source from the list (in this example, it's ODMTEST), and click on next.
从列表中选择适当的Cognos数据源(在本例中为odmtest),然后单击next。
Select the Synchronize the data with this source server option, and select g_two as the server from the drop-down list.
选择Synchronizethedatawiththissourceserver选项,并从下拉列表中选择 g_two作为源服务器。
Do not select the option to Include data sources and connections unless the data source connecting to the application database has not previously been created in Cognos BI 10.1.
不要选中包含数据源和连接的选项,除非连接到应用程序数据库的数据源之前在CognosBI 10.1中没有创建。
Using a select statement to select from a data source into an external table (see Listing 3).
使用select语句从一个数据源选择构成外部表的数据(参见清单3)。
Using a select statement to select from a data source into an external table (see Listing 3).
使用select语句从一个数据源选择构成外部表的数据(参见清单3)。
应用推荐