Skip to main content
Open

Sending SQL statement as it is

Related products:Transformers
  • August 30, 2023
  • 1 reply
  • 58 views

arthur_bazin
Contributor

Refering to this thread and this other thread, FME is doing a lot of things on our sql statement without asking us...

As a PostgreSQL database ingineer, my SQL scripts can be really complex and I want FME to send it to the database wihtout encapsulated it into some darkmagic procedure...

It could be great to have an option to tell FME to send the statement to the database as it is. The dev have to check for the commit part and all of course.

1 reply

arthur_bazin
Contributor
Forum|alt.badge.img+9
  • Author
  • Contributor
  • July 15, 2024

I found another situation.

I want to use FME to perfom a VACUUM FULL after a set of operations.

But I can’t with FME because there is no transformer that allows me to send SQL command without being in a transaction block.

It could be great to have an advanced option in the SQLExecutor to avoid packaging our SQL into a transaction block an to sending it just as it is.

It could allow us to perform VACUUM.


Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings