Truncate table and insert data from a view

Anonymous — Fri, 12 Jul 2019 09:00:14 GMT

First i recover my ID_MAX and save it in a context (Done), after i want to truncate my table but i get an error. I don't understand why he didn't found my table. If someone can explain how it's work.

Thank you.

Re: Truncate table and insert data from a view

Anonymous — Fri, 12 Jul 2019 09:11:42 GMT

So it's was just a basic SQL mistake… i wrote server_myTable and it's was server.myTable…

I close the subject.

topic Re: Truncate table and insert data from a view in Talend Studio

Truncate table and insert data from a view

Re: Truncate table and insert data from a view