Once you configure the BdpConnection component, you can start to write SQL commands to select tables from the SAMPLE database.
配置好BdpConnection组件之后,便可以开始编写对SAMPLE数据库中的表进行select操作的SQL命令。
You can easily list tables containing spatial data and select tables to display as a map using a combination of points, lines, and polygons.
可以很方便地列出包含空间数据的表,并可将表展示为由点、线、和多边形组成的图。
Select all the tables in the schema.
选择该模式中的所有表。
Select the contents of both tables with a join and you can produce a shape and coordinate file like that shown below.
选择两张表组合在一起后的内容,然后可以生成如下所示的图形和坐标文件。
Using views in a SELECT statement can restrict the join order of the tables and limit the query optimizer's choices when considering access plans.
在select语句中使用视图,可以限制表的连接顺序,同时也限制查询优化器在考虑访问计划时的选择。
Therefore, if your report USES only the tables from the data mart, select this check box; if your report USES any live tables, clear this check box.
因此,如果您的报告只使用来自数据集市的表格,那么您可以选中复选框;如果您的报告只使用活性表格,就清除该复选框的选择。
Map tables for replication and select the replication method.
映射用于复制的表并选择复制方法。
This widget was the checkbox in the top left corner of tables that allowed you to select/deselect all the checkboxes in that column.
这个小部件是在表的左上角上的复选框,它允许您选择或取消选择该列上的所有复选框。
The following SELECT statement will return any SQL tables or physical files that have some allocation on SSD in schema (library) MJATST.
下面的select语句将返回MJATST模式(库)中在SSD上有一些分配的任意sql表或物理文件。
In addition, some tables contain columns where you can select a type.
另外,有一些表格包含了您可以从中选择类型的列。
You can use standard SQL SELECT statements on both message data and database tables.
您可以在消息数据和数据库表上使用标准的SQLSELECT语句。
Typically, you create a SELECT statement, perhaps JOINing many tables together to yield a row.
通常,将创建select子句,可能需要把许多表join在一起才能得到行。
To perform an analysis of text in database tables, you first explore the available information to select the relevant text columns for the analysis.
为了对数据库表中的文本进行分析,首先要研究可用的信息,选择要分析的相关文本列。
The from component of a SELECT statement indicates from which table (or multiple tables) the data will be extracted.
select语句的FROM组件指明将从哪个表(或多个表)中提取数据。
Having the constraints defined in the database allows DB2 to know relationships between tables and in some cases allows it to select better access plans based on that knowledge.
在数据库中定义约束使DB 2可以知道表之间的关系,并且在某些情况下允许DB 2根据这样的知识选择更好的访问计划。
To perform an analysis of text in database tables, first explore the available information to select the relevant text columns for the analysis.
要在数据库表中执行文本分析,首先利用可用的信息来选择要分析的相关文本列。
Select the ACCOUNT table from the list of available tables for this schema.
从这个模式的可用表列表中选择account表。
However, instead of forcing the user to type the literal name of the database table, it would be easier to select one of the existing tables.
不过,选择一个现有表会更容易一些,这样就不必要求用户逐字输入数据库表的名称。
In that case, the SELECT statement verified that the tables were created and loaded properly.
在该示例中,select语句验证了表是否已正确创建和加载。
Select the ACCTPROFILE table from the list of available tables for this schema.
从该模式的可用表格列表中选择acctprofile表。
When you select a set of data from a table or tables in a database, the returned data is known as a cursor.
当您通过数据库的一个或多个表选择一组数据时,返回的数据也称为游标。
You can select the tables that you want to migrate and extract the DDL into a file.
此时可以选择所要迁移的表,并将DDL提取到一个文件。
Set the table name to RETAIL_RULES and, for the schema, select the default schema where the RETAIL tables reside.
将表名称设置为 RETAIL_RULES,对于模式,选择这个RETAIL 表所在的默认模式。
Now, when the same query is run, the native SQL that is generated is a single select statement joining the two tables from the different catalogs at the database tier as shown in Illustration 10.
现在,当同一个查询运行时,生成的原生sQL是单个选择语句,在语句在数据库层联接来自不同目录的两个表,如图10所示。
Select all tables for import, then Next.
选择导入所有表,然后单击Next。
The following SELECT statement will return any indexes on tables or physical files that have some allocation on SSD in schema (library) MJATST
以下SELECT语句将返回MJATST模式(库)中在SSD上有一些分配的的表或物理文件的任何索引
For this example, the source and target tables have similar structures, so select One-to-one Mappings.
对于这个示例,源和目标表具有相似的结构,所以选择one - to - oneMappings。
The SELECT clause has all the columns from the tables (full row replication)
SELECT子句含有来自表中的所有列(完全行复制)
From the response object you can obtain any element (s) of the page, such as links, applets, form, select, check box, input types, tables, images, and so on.
通过响应对象,您可以获取页面的任何元素,比如链接、applets、表单、选择、复选框、输入类型、表格、图像,等等。
On the Source Tables page, select the source table that you want to replicate from.
在SourceTables页面上,选择需要进行复制的源表。
应用推荐