Hello,
please, I just wanna ask, if FME Desktop is able to generate SQL update script for ORACLE database, e.g. in sql format?
Example:
UPDATE sample
SET band='CCC'
WHERE fid=123456
Thank You for tips!
Lubo
Page 1 / 1
A way of doing this is concatenating a text attribute using the StringConcatenator or the AttributeCreator and writing the text (SQL statement) to a Text File Writer.
why not it's a matter of creating the statement and passing it to the sql executor to be executed...
and that is exactly what a database writer will do if you use it to update the table, just look at the log.
Hope this helps.
Thank You! Both tips helped me so much!