topic Re: truncating without insert/update in Talend Studio

truncating without insert/update

Anonymous — Tue, 31 Jan 2017 14:22:54 GMT

Hi,
A newbie question I am afraid!
how do i execute a truncate table(s) set of statements (mysql database ) at the start of a job . I do not want to load records at this point(so no using tmysqloutput).
I have tried to use tMysqlRow but recieve an error i assume means that this component cannot run DDL statements. I would like to dynamicly select which table to truncate based on runtime context so a stored proc is not going to work.
comments and assistance appreciated

regards
Neil

Re: truncating without insert/update

TRF — Tue, 31 Jan 2017 15:12:58 GMT

Hi,
Have a look here thread.
Should also works with tMysqlRow (I suppose so).

Regards,
TRF

Re: truncating without insert/update

Anonymous — Tue, 31 Jan 2017 17:51:21 GMT

I have tried this . I dont think Mysql supports this syntax as i cant run it on a basic editor outside of talend.

Re: truncating without insert/update

vapukov — Tue, 31 Jan 2017 20:33:26 GMT

tMySQLRow with command - "truncate table your_table_name;"

or "TRUNCATE TABLE "+((String)globalMapGet("v_your_table_name")) for make it dynamic
You can run more than 1 command line in same component, but this depends from database and You may need read information for additional JDBC string parameters

Redshift on picture - just examples, I use this and for MySQL and other types

Re: truncating without insert/update

Anonymous — Wed, 01 Feb 2017 11:51:41 GMT

Thanks!

Works fine now.

i added "allowMultiQueries=true" under additional JDBC paramers so i can run multiple statements.

Re: truncating without insert/update

Anonymous — Wed, 01 Feb 2017 11:53:05 GMT

How do i now mark this as resolved?

Re: truncating without insert/update

Anonymous — Mon, 06 Feb 2017 06:15:21 GMT

Hi,
You can click the "Set this topic as resolved" link which is right underneath your initial post? This way, other users will be informed that this thread has been resolved.
Best regards
Sabrina