Arno,
> In an FME file you can use the DEF keyword while reading racle spatial.
> I always use this keyword to put a sql statement wich combines several
> tables (spatial and non-spatial). I'm searching for a way to set this
> keyword in the workbench. Does anybody know a way how to do this?
There's several options:
- In Workbench: Tools -> Edit Header, will allow you to edit the
workbench header.
- You may be able to use the SQLExecutor and/or OracleQuerier (although
this may not fit into what you're trying to do, as it's part of the
workbench process itself)
- I seem to recall the Oracle readers to have an option to send a SQL
statement to the database before data is read. This is a setting in the
Reader itself. I don't have access to FME for Oracle at the moment, so I
can't check this.
Hope this helps.
--
Hans van der Maarel
Red Geographics
www.redgeographics.com / [EMAIL PROTECTED]
Get the maximum benefit from your FME, FME Objects, or SpatialDirect via our
Professional Services team. Visit www.safe.com/services for details.
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/fme/
<*> To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
