I have a question about a process.  I want to extract features from 
an SDE database using features from a separate Oracle database using 
something similar to a SQL IN clause.

Step 1:
I want to query the Oracle database, bring back a list of ID values.

Step 2:
Feed that list into a separate SDE database and query a point later 
using that list.

Step 3:
Where there are matches I want to use those returned points to 
perform a point-in-polygon operation on the same SDE database in 
another layer.

I'm having trouble finding a transformer that enables me to use the 
list of returned values like an IN clause would be used in SQL, or a 
WHERE table1 = table2 evaluation.

Thanks in advance,
st



For insights into what's up at Safe Software and what's on the development 
horizon, visit Safe's blog at spatial-etl.blogspot.com.

Safe Software has also made slides available that outline enhancements planned 
for FME 2007. The slides are from the "Road Ahead" presentation given on Day 2 
of the FME Worldwide Users Conference. To view these slides, visit 
www.safe.com/2006uc.

 
Yahoo! Groups Links

<*> To visit your group on the web, go to:
    http://groups.yahoo.com/group/fme/

<*> Your email settings:
    Individual Email | Traditional

<*> To change settings online go to:
    http://groups.yahoo.com/group/fme/join
    (Yahoo! ID required)

<*> To change settings via email:
    mailto:[EMAIL PROTECTED] 
    mailto:[EMAIL PROTECTED]

<*> 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/
 

Reply via email to