Skip to main content
  • EN

Hi

There is this really cool writer called Generic (Any Format). I tried to use this writer to keep my scripts independently from the DBMS I'm writing into. This would enable me to switch DBMS very fast, and just to have one lean script to work with PostgreSQL, MS SQL Server, Oracle, or Teradata.

Thing is that I make use of the parameter fme_db_operation in almost all my scripts. Some features lead to an INSERT, some trigger an UPDATE, other a DELETE.

I couldn't make the Generic ( Any Format) writer to accept fme_db_operation. It always leads to an INSERT operation.

How do I use the Generic ( Any Format) writer with the parameter fme_db_operation?

Not sure if this will work and no time to try it myself, but if you add writers for the database formats you want the Generic writer to support you'll gain access to their parameters. You don't need to actually write data to them, they don't even have to have feature types, they just have to be there.

Reply


Community Stats

30,108
Posts
114,295
Replies
37,743
Members
Terms & ConditionsCookie settings
A product of
Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.