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