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" <[EMAIL PROTECTED]> 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 <[EMAIL PROTECTED]> 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/
