I don't think you can perform a TRUNCATE query on ArcSDE but you can use a DELETE. The result is the same but it take more time. Here is what I do to delete all records in a SDE table before process a translation:
I use a 2DCreator with X Y COORDINATES 0 0, NUMBER TO CREATE 1, CREATE AT END NO. The geometry of the feature generated by 2DCreator does not matter (you can use any coordinates you want). The goal is only to get an input for ArcSDEQUERIER. In ArcSDEQUERIER use: QUERYMODE = DELETE SEARCH_METHOD = SDE_NONE WHERECLAUSE = Another solution would be to use a systemcaller instead of ARCSDEQUERIER in order to call the ArcSDE utilities. Regards. ---------------------------------------------------------------- Olivier Gayte Veremes http://www.veremes.com/ 42 av. des Jardins 66240 St Esteve France tél +33 (0)4-68-38-65-27 mobile +33 (0)6-60-49-83-81 fax +33 (0)4-26-68-98-35 [EMAIL PROTECTED] ---------------------------------------------------------------- ----- Original Message ----- From: "harv990" <[EMAIL PROTECTED]> To: <[email protected]> Sent: Tuesday, June 28, 2005 8:35 PM Subject: [fme] How to delete records in SDE before translating > 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 > > > > > > > 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/
