--- In [email protected], "harv990" <[EMAIL PROTECTED]> wrote:
> Hi,
> I did a quick search on delete and SDE and didn't find too much on
this
> topic. How do you delete all the records from a feature class in
SDE
> (truncate) before translating new records into it.
>
> Thanks,
> Gary
I have exactly the same need to truncate SDE or normal Oracle-tables
before loading data. Earlier posts has suggested SQLExecutor in
Workbench (se below), but I have never been able to get it to work.
If anyone could post an example workbench file on how to use
SQLExecutor to truncate tables (or any other use) I would be forever
grateful.
Extract:
"
There is a @SQL function (SQLExecutor Transformer in Workbench)
available. You can use this to truncate your table before writing to
it
or you can use a select query to just delete some of the rows in your
table.
"
/Tomas
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/
