truncate insert data in table if it don't use

Five Stars

truncate insert data in table if it don't use

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

Employee

Re: truncate insert data in table if it don't use

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...

Five Stars

Re: truncate insert data in table if it don't use

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