由普遍存在PSQL读者处理的指令下面列出。显示的后缀是由当前的前缀
数据集
必需的/Optional:必需的
This is the ODBC data source name.
Example:
普遍存在_DATASET citySource
Workbench参数：Source Pervasive PSQL DSN
def
必需的/Optional:必需的
这syntax of the definition is:
pervasive_def\ [pervasive_where_clause ] \ [ ] +
或者
普遍存在_DEF\ [pervasive_sql_statement ] \
这<tableName>必须匹配数据库中现有普遍存在PSQL表的名称。这将用作从表读取的所有功能的特征类型。此规则的异常是使用时pervasive_sql_statement指示。在这种情况下，defname may be any valid alphabetic identifier; it does not have to be an existing table name – rather, it is an identifier for the custom SQL query. The feature type of all the features returned from the SQL query are given the query name.
这<fieldType>of each field must be given, but it is not verified against the database definition for the field. In effect, it is ignored.
这definition allows specification of separate search parameters for each table. If any of the per table configuration parameters are given, they will override, for that table, whatever global values have been specified by the reader directives such as thewhere_clause.。如果一个ny of these parameters is not specified, the global values will be used.
这following table summarizes the definition line configuration parameters:
Parameter |
Contents |
pervasive_where_clause. |
这将指定应用于图层功能属性的SQL，以限制返回的功能集。如果未指定此项，则返回所有行。如果该指令将被忽略pervasive_sql_statementis present. |
pervasive_sql_statement |
This specifies an SQL SELECT query to be used as the source for the results. If this is specified, the Pervasive PSQL reader will execute the query, and use the resulting rows as the features instead of reading from the table |
如果不<然而>指定了，将读取表中的所有行作为单个功能返回。如果一个<然而>is specified, only those rows that are selected by the clause will be read. Note that the
这Pervasive PSQL reader allows one to use thepervasive_sql_statement参数指定任意SQLSELECTquery on thedef线。如果指定了这一点，FME将执行查询，并使用查询返回的每一行数据来定义至少一个功能。这些功能中的每一个都将被给出命名的特征类型def行，并将包含由返回的每列的属性SELECT。在这种情况下，所有defline parameters regarding aWHEREclause or spatial querying are ignored, as it is possible to embed this information directly in the text of the
In the following example, the all records whose ID is less than 5 will be read from the supplier table:
pervasive_def供应商\ pervasive_where_clause“id <5”\ id integer \ name char（100）\ city char（50）
In this example, the results of joining the员工和citytables are returned. All attributes from the two tables will be present on each returned feature. The feature type will be set tocomplex。
pervasive_def complex \ pervasive_sql_statement \“from employee，city的select * where employee.citite = city.name”
where_clause.
必需的/Optional
可选的
此可选规范用于限制每个表中读取器读取的行。如果给定的表没有pervasive_where_clause.或者pervasive_sql_statementspecified in itsdef线，全球< ReaderKeyword > _WHERE_CLAUSE如果存在的话，值将作为WHERE用于生成结果的查询的说明符。如果是一个表def线确实包含自己的pervasive_where_clause.或者pervasive_sql_statement,它将覆盖全球WHERE条款。
此子句的语法是：
pervasive_where_clause
注意：
下面的示例仅选择长度超过2000的功能：
pervasive_where_clause length> 2000
Workbench Parameter
在哪里子句
ids.
必需的/Optional:可选的
This optional specification is used to limit the available and defined database tables that will be read. If noids.are specified, then no tables are read. The syntax of theids.指示is:
普遍存在_IDs\ … \
功能类型必须与使用的功能类型匹配deflines.
这example below selects only the历史表格用于翻译期间的输入：
pervasive_ids历史
read_cache_size.
必需的/Optional:可选的
此指令控制读取器如何从数据库中检索行。这必须是一个必须大于0的数值。
这read_cache_size.is used to determine the number of rows that are retrieved at one time into local memory from the data source. For example, if theread_cache_size.is set to 10, after the reader is opened, the reader will read 10 rows into local memory. As features are processed by FME, the reader returns the data from the local memory buffer. As soon as you move past the last row available in local memory, the reader will retrieve the next 10 rows from the data source.
This directive affects the performance of the reader, and will result in significantly degraded performance if incorrectly set. The optimum value of this directive depends primarily on the characteristics of individual records and the transport between the database and the client machine. It is less affected by the quantity of rows that are to be retrieved.
默认情况下，read_cache_size.is set to 10. This value has been determined to be the optimal value for average datasets.
Workbench参数：一次获取的记录数量
Retrieve_all_schemas.
此参数仅在生成映射文件时，生成工作空间或在FME对象应用程序中检索模式时适用。
When set to是的, schemas for all of the tables and feature classes in the database are returned.
When set to不（或丢失），如果RETRIEVE_ALL_TABLE_NAMESis similarly set to不（或丢失），仅返回IDS参数所请求的模式。
必需的/Optional
可选的
Values
YES | NO (default)
不：读取器将返回ID中指定的要素类型的模式。如果IDS中没有指定功能，则FME返回所有表的架构功能。
如果未指定此值，则假定为否。
YES:指示读者返回数据库中表的所有模式。
Mapping File Syntax
不适用。
FME Objects applications would includeRetrieve_all_schemas.followed by “YES” in the parameters array passed toIFMEUniversalReader::open()。
Workbench Parameter
不适用
RETRIEVE_ALL_TABLE_NAMES
此参数仅适用于生成映射文件时，生成工作区或在FME对象应用程序中检索模式时。
When set to yes, and ifRetrieve_all_schemas.is set to no (or missing), names for all of the tables and feature classes in the database are returned. When set to no (or missing), and ifRetrieve_all_schemas.is similarly set to no (or missing), the schemas requested by the IDs directive are returned.
Note:IfRetrieve_all_schemas.也设置为是的，然后Retrieve_all_schemas.优先。
必需的/Optional
可选的
Values
YES | NO (default)
Mapping File Syntax
不适用。
FME Objects applications would includeRETRIEVE_ALL_TABLE_NAMESfollowed by “YES” in the parameters array passed toIFMEUniversalReader::open()。
Workbench Parameter
不适用（在您浏览表格列表时使用）
expost_attrs.
此指令允许将格式属性的选择进行明确添加到读取器功能类型。
一旦生成，这类似于读取器功能类型上的曝光格式属性类似;但是，它甚至更强大，因为它使WorkBench以外的模式驱动的应用程序能够访问和利用这些属性，就好像它们在架构上显式作为用户属性一样。
这result of picking a list of attributes is a comma-separated list of attribute names and types that will be added to the schema features. Currently all reader feature types will receive the same set of additional schema attributes for a given instance of the reader.
必需的/Optional
可选的
Mapping File Syntax
不适用。
虽然FME对象应用程序可以调用此指令，但未记录所需格式。
This directive is intended for use in our GUI applications (for example, Workbench) only.
Workbench Parameter
Additional Attributes to Expose