Hi Rune, I think that Jeff is saying that it's easier to use an SDE writer than to use a transformer. I think I'd agree. In the past I have always done it that way.
What you'll probably want to do is read from the source data (TABLE_1) use a Joiner to merge in attributes from the update data (TABLE_2) and then write it back to the SDE database using the update mode. The update key attributes are set in the writer feature type parameters - see http://www.fmepedia.com/index.php/Sandbox for an example screenshot. I don't think you could write the update table straight to the destination (even in update mode) unless it had ALL the information on it you required - eg if it only had field_1 then that's all you'd get on the destination (I think) Hope this helps Mark Mark Ireland, Senior Product Specialist Safe Software Inc. Surrey, BC, CANADA [EMAIL PROTECTED] http://www.safe.com Solutions for Spatial Data Translation, Distribution and Access --- In [email protected], "gullstrom" <[EMAIL PROTECTED]> wrote: > > Thanks for your answer Jeff, > > I don't get it though... > > What I'm trying to achieve is what would look in oracle like: > UPDATE TABLE_1 A SET FIELD_1 = ( > SELECT FIELD_2 FROM TABLE_2 B > WHERE A.KEY = B.KEY) > > When I use the ARCSDEQUERIER, I select SDE_NONE in the 'Search > Method' dialog, then define a link to the base sde table in > the 'Where Clause' dialog (eg. a.key = b.key), then for 'Query Mode' > I use UPDATE. > > The above doesn't seem to work. Maybe also because source feature > class and target feature class are the same. > > Your remark that the update is always done on the objectid puzzles > me. I see that when I use either of the last 2 options in > the 'Combine Attributes' dialog I get all the attributes of both > input feature classes. This would then enable me to map any > attribute to any output attribute, or? > > thanx > > rune > > You say the updates are always done on the object field. > --- In [email protected], "Jeff Konnen" <jaykayone@> wrote: > > > > Hi rune, > > > > to update data in SDE, > > > > you can also use the ArcSDE 3.0 writer, or the Geodatabase ArcSDE > Writer. > > What you have to do is define the KEY-Field for updating in the > properties > > of your destination featureset. > > > > The ArcSDEQuerier works in update mode, but the updates will > always be done > > on the OBJECTID - field, which is not necessariliy what you want. > > > > As for the Joiner Transformer, I do not think it can update > features. It > > gets you joined features and adds them to your querying feature, > but the > > update process has do be done by the ArcSDEQuerier or one of the > ArcSDE > > Writers. > > > > See this page for more infos: > > > > > http://www.fmepedia.com/index.php/Which_READER_and_WRITER_should_I_us > e_for_Geodatabase > > > > I do not know if these steps work on Informix, but I can assure > you they > > work on Oracle! > > > > Greetings, > > Jeff > > > > On 5/14/07, gullstrom <gullstrom@> wrote: > > > > > > Hi all, > > > > > > I want to update attributes of a feature class (argis > 9.2/informix/fme > > > 2007) but I can't get it to work. It seems to me I have 2 > options: the > > > joiner transformer or the arcsdequerier. The joiner works fine > but > > > can't work with informix, the arcsdequerier doesn't work at all > in > > > update mode. How do you update attribute in a given feature class > > > using (non spatial) info like a common key? > > > > > > thanks in advance, > > > > > > rune > > > > > > > > > > > > > > > > > -- > > Jeff Konnen > > INSER SA > > Switzerland > > +41 (0) 21 643 77 11 > > > For insights into what's up at Safe Software and what's on the development horizon, visit Safe's blog at spatial-etl.blogspot.com. Love FME? Then open your diary to March 6-7, 2008 and write this... "Second Worldwide FME User Conference - Must Attend!" See http://www.safe.com/company/fmeuc2008/index.php for more details. Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/fme/ <*> Your email settings: Individual Email | Traditional <*> To change settings online go to: http://groups.yahoo.com/group/fme/join (Yahoo! ID required) <*> To change settings via email: mailto:[EMAIL PROTECTED] mailto:[EMAIL PROTECTED] <*> 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/
