Hi Some formates - Oracle i think - has a pre sql directive letting you run a any sql command prior to the translation
a different approach is to use the new FME_BEGIN_TCL command, with this command you can connect to the database before translation, and then delete / create or in other ways manipulate the databse this is a bit more than standard WB but on the other hand you can do whatever you like to do with the databse. some times back i posted an exampel on how to log translation paramters to a databse using this command and odbc. have fun Peter Laulund National surve and cadastre, Denmark >From: "Bryan Waller" <[EMAIL PROTECTED]> >Reply-To: [email protected] >To: [email protected] >Subject: RE: [fme] Re: How to delete records in SDE before translating >Date: Wed, 29 Jun 2005 09:38:46 -0600 > >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 > > > > > > _________________________________________________________________ Få alle de nye og sjove ikoner med MSN Messenger http://messenger.msn.dk/ 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/
