I have tried reading out to a file geodatabase and then reading that out with the where clause to shapefile but would like to try something more direct
Question
What is the best way to add a whereclause query to an ArcSDE layer and extract to ESRI shapefile?
+67- Celebrity
In the reader you can specify a WHERE clause (SDE/GDB) The GDB API reader doesn't have a WHERE statement.
Alternately you can read in all the data and use a Tester with your WHERE clause in it