Truncate table and insert data from a view

Highlighted
One Star

Truncate table and insert data from a view

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.


Accepted Solutions
One Star

Re: Truncate table and insert data from a view

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

I close the subject.


All Replies
One Star

Re: Truncate table and insert data from a view

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

I close the subject.

What’s New for Talend Summer ’19

Watch the recorded webinar!

Watch Now