This is something that I have also dealt with. Currently I truncate with SDE command line before loading with FME.
I have been leery of using the SQLExecutor. If it is used for an SQL truncate are the associated SDE tables etc. correctly cleaned up? The command line seems to do this cleanly with very little fuss and only referencing one table. Bryan Bryan Waller, GIS Specialist Midwest Survey Inc. [EMAIL PROTECTED] ph.403.244.7471 (main) ph.403.735.9344 (direct) fax.403.244.2466 www.midwestsurveys.com/ -----Original Message----- From: tomlind65 [mailto:[EMAIL PROTECTED] Sent: June 29, 2005 7:11 AM To: [email protected] Subject: [fme] Re: How to delete records in SDE before translating --- 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 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/
