You cannot alter the external table schema.
不能改变外部表模式。
You cannot use an external table in a sub-query.
不能在子查询中使用一个外部表。
To compare, create an external table with NUMROWS
为了进行比较，创建一个带有 NUMROWS 的外部表
Create an external table using the following DDL.
使用以下ddl创建一个外部表。
Create the external table using the following query.
使用以下查询创建外部表。
You cannot run UPDATE STATISTICS against an external table.
不能针对一个外部表运行updateSTATISTICS。
LBAC security cannot be imposed on external table data files.
LBAC安全性不能施加在外部表数据文件上。
This row can now be successfully accessed through an external table.
这一行现在可以通过一个外部表成功访问。
External table statements can also be used as static statements.
外部表语句也可以用作静态语句。
External table data files are excluded from all forms of replication.
外部表数据文件不能进行任何形式的复制。
Select the rows from the external table using the query in Listing 11.
使用清单11中的查询选择外部表中的行。
An external table cannot be a target table in the MERGE statement.
外部表不能是merge语句中的目标表。
No table is an external table, remote table, view, or derived table.
没有外部表、远程表、视图或派生表。
Also, the selection from the external table can be prepared and executed.
而且，从外部表选择可以获得准备并得以执行。
An external table can be created using one of the following three methods.
外部表可以采用以下三种方法创建。
NUMROWS: the approximate number of rows that the external table can possibly have.
NUMROWS：外部表可能拥有的大致行数。
Using the CREATE EXTERNAL TABLE statement with column specification (see Listing 1).
使用带有列指定的CREATEEXTERNAL table语句(参见清单1)。
NUMROWS is used to provide an approximate number of rows that an external table can have.
NUMROWS用于提供一个外部表可能拥有的大致行数。
Act of reading data from a table in the database and inserting it into an external table.
外部表的数据加载是指从外部表中读取数据并加载到数据库表中。
Using a select statement to select from a data source into an external table (see Listing 3).
使用select语句从一个数据源选择构成外部表的数据(参见清单3)。
Because they are not logged, the external table data files are excluded from all the replications.
由于不载入日志，外部表数据文件都不能进行复制。
External tables provide a normal table interface to data files that reside in the underlying operating system.
外部表对驻留在底层操作系统中的数据文件提供一个普通的表界面。
Note that at the time of creating an external table, the data files associated with the external table need not exist.
注意，在外部表创建之时，与该外部表关联的数据文件不需要存在。
DATAFILES is a mandatory clause for each external table. It specifies the file path where the data can be read from or written to.
DATAFILES是每个外部表的必需子句，它指定读写数据的文件路径。
To create an external table "et_customer" with the same schema as customer table with a delimiter "|", you can use the following DDL statement.
要使用分隔符“|”创建与customer表具有相同表模式的外部表“et_customer”，可以使用以下ddl语句。
Support of external table creation, access, load, and unload from within the stored procedures makes it easier to perform the batch load and unload operations.
存储过程中的外部表创建、访问、加载和卸载支持允许您更轻松地执行批加载和卸载操作。
The example code in Listing 19 creates a distinct user-defined type called "birthday" and is being used as the column type while creating the external table.
清单19中的示例代码创建了一个明显的名为“birthday”的用户定义类型，并在创建外部表时用作列类型。
Selecting from an external table reads the data from the data file(s) and provides it in the form of rows and columns as if it was read from the normal base table.
从外部表选择可从一个或多个数据文件读取数据，并以行和列的形式提供该数据，就好像从常规基表读取数据一样。
Define external table with multiple files instead of one huge single file; when executing load or select operation with PDQ priority set, IDS exploits the parallelism.
使用多个文件、而不是一个超大文件定义外部表；使用PD Q优先集执行加载或选择操作，以便IDS利用“并行性”。
If the base table to which the data is loaded from the external table is defined to be a RAW table without indexes, the IDS server USES light appends to load the data.
如果将从外部表加载数据所到的基表定义为不带索引的raw表，则IDS服务器将使用“轻追加法”加载数据。
应用推荐