Hi Ramesh.
In the case of writing to ArcSDE Geodatabase I think you
have to use the SQLExecutor to perform an SQL-query like "DELETE FROM
<mytable>" or "DROP TABLE <mytable>".
DROP TABLE is probably faster, but if the table dose not
exist an error will be raised and FME will stop. DELETE FROM will always work
without errors as long as the table is there.
DROP TABLE might also get you in trouble if there are
relations and topologies and stuff....
If you use a NullGeometryCreator to create an object first
of all in your workspace and send that object to the SQLExecutor you willmake
sure that the SQL-query is executed before any other data is entering the
database.
This way you can add many SQLExecutors.
I haven't tried this, so no promises. This solution might
fall on the time that it takes for the query to execute... Well try it and let
us know how it goes!
Good luck /Nisse
PS.
In Oracle and DB2 writers you have an option to run
SQL-queries as a part of the reader/writer, but that will require that you add
another writer to your Workspace and that you have arcsde on Oracle (don't know
if arcsde runs on db2).
Open the help in FME Workbench, search for BEGIN_SQL and
you'll find the help for this.
DS.
Från: [email protected] [mailto:[EMAIL PROTECTED] För Ramesh Choudary
Skickat: den 20 mars 2006 12:36
Till: [email protected]
Ämne: [fme] update the ArcSDE feature class
Dear all,
I have written an FME file which writes data from DGN to ArcSDE
Geodatabase.I am getting the error if the Feature class already exists.I want
the FME should delete the existing one and create the new feature class with
same name.I tried to change different options in transaction parameters..didn't
work..
I really appreciate if anybody in the form gives me how can I acheive the
task.
thanks in advance
kind regards
Ramesh
Brings words and photos together (easily) with
PhotoMail - it's free and works with Yahoo! Mail.
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
- Visit your group "fme" on the web.
- To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
- Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
