topic Re: Delete cascade in Talend Studio

Delete cascade

djugal — Sat, 16 Nov 2024 12:40:14 GMT

I have a job whi9ch performs a delete operation. in postgresql db output, delete as option selected & deletion key selected.
Somehow the delete doesnt work.
I guess the reason might be key dependency on other tables as key value.
So is there a delete cascade facility in talend.
(I am using Integration suite)
Regards,
Jugal

Re: Delete cascade

Anonymous — Thu, 22 Sep 2011 05:32:33 GMT

Hi
No, it is impossible with tPostgresqlOutput component, you need to disable the constrain, like dropping the foreign key constraint before deleting and execute the SQL statement on tPostgresqlRow component.
Best regards,
Shong

Re: Delete cascade

djugal — Thu, 22 Sep 2011 06:19:03 GMT

Hi.
can i write the on delete cascade sql in postgresqlrow component without dropping the constraint ??

Re: Delete cascade

Anonymous — Thu, 22 Sep 2011 06:23:47 GMT

Hi
Maybe, I did't do it before, you can try the suggestion mentioned on the following URL and let me know the result,
http://stackoverflow.com/questions/129265/cascade-delete-just-once
Best regards
Shong

Re: Delete cascade

djugal — Thu, 22 Sep 2011 14:12:34 GMT

hi,
how do i use the input coming out of tmap ?
job is like this
db2i/p > tmap > postgresqlo/p (Action on data : delete)
Now i change it to :
db2i/p > tmap > postgresrow
how do i use the id coming out of tmap to map query in postgresrow, i cant use
delete from xxx where uid=row5.xxxxxx ??

Re: Delete cascade

djugal — Fri, 23 Sep 2011 07:16:22 GMT

Still not working,
After removing constraint
I tried, in Row component : DELETE FROM table where id="+globalMap(map_delete.id)
Any Idea ?
Thanks,
Jugal

Re: Delete cascade

djugal — Fri, 23 Sep 2011 13:21:36 GMT

I also tried with context variable like:
DELETE FROM table where id="+context.uid
I set the context variable between tmap & row component.
but still not working ??
Any Help....