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
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
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!
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.