topic truncate insert data in table if it don't use in Talend Studio

truncate insert data in table if it don't use

lemufty — Wed, 24 Jan 2018 23:14:47 GMT

hello,

In my job, i truncate table and after insert data if table don't use.

so this is my problem that i want to resolve.

so if my table is used by another process( reading by another process ) .i wait during 60 second and try again(trucante and insert)

i don't know how can i modelize with talend.

anybody have an idea. than you

Anonymous — Thu, 25 Jan 2018 04:22:56 GMT

If table is already read by another process, any database won't allow to truncate that table.

This is already handle at database level. Whatever request comes first to database (read or truncate) will take precedence...

if you just want Truncate + Insert, use any t<db>output component of talend and do it.. for example tDB2output got option for Truncate + Insert...

lemufty — Thu, 25 Jan 2018 10:24:46 GMT

But if the table is already use by another process when i try to truncate this table, the job will generate an error.

So i don't want to have error. So i want to wait 1 mn when this table is used and try again