SQL执行器

Features that trigger a SQL query to be executed.

Features that result from the SQL queries.

输入发起者具有附加属性的功能(_matched_records) that contains the number of features generated as the result of SQL query initiated by that feature.

当SQL执行失败时，原始发起者功能通过这个端口输出，并带有一个名为_读卡器错误包含最后一条错误消息。

Select the database format and dataset, including any format-specific parameters.

可以保留默认设置，也可以使用坐标系库中的选择。

Specify the SQL query using the text editor.

Multiple SQL commands can be delimited by a character specified using the keywordFME_SQL_DELIMITER，嵌入在SQL语句的最开头。紧跟在该关键字后面的单个字符将用于拆分SQL，然后将SQL发送到数据库执行。（注意：在字符前面加一个空格。）

单个语句前面可以加上连字符，表示应该忽略错误。

The following example contains two SQL commands where errors from the first command will be ignored:

FME_SQL_DELIMITER ;

选择*从TABLEA;

从表B中选择*；

输入要在查询创建的功能上公开的属性的名称。属性将按列表中指定的相同顺序输出。

注：默认情况下，生成的特征的属性是隐藏的。通过输入属性名称指定要公开的属性。单击要公开参数的属性旁边的浏览按钮。您还可以使用SQL语句填充列表，方法是按“从SQL查询填充…”，然后输入SQL查询。第一个匹配功能中的列将用于填充属性列表。

结果Attributes Only: The result feature attributes consist solely of the query results.

Keep Initiator Attributes if Conflict：结果功能属性是查询结果和发起程序功能属性的组合。如果存在冲突，则从启动器功能获取属性值。

Keep Result Attributes if Conflict: The result feature attributes are a combination of both the query results and initiator feature's attributes. If there is a conflict, attribute values are taken from the query results.

结果Geometry Only：结果特征的几何图形仅由SQL查询生成的几何图形组成。

仅启动器几何体：The geometries of result features consist only of those present in the initiator features.

聚合启动器和结果几何体: Result features are populated with geometries from both the initiator features and the SQL query.