topic Re: Get LastInsert ID for each rows in main in Talend Studio

Get LastInsert ID for each rows in main

Anonymous — Sat, 16 Nov 2024 07:57:39 GMT

Hi,
Here's a part of my schema

Both LastInsertId return or :
- The last one ID

- A previously commited object id

I want my id, like 1 -> 2 -> 3 etc...

Thanks !

Re: Get LastInsert ID for each rows in main

fdenis — Mon, 16 Jul 2018 15:03:22 GMT

I think you do not have to commit first. link yout commit with an on subjob Ok

Re: Get LastInsert ID for each rows in main

Anonymous — Tue, 17 Jul 2018 08:18:47 GMT

I do not have possibility to add "on subjob ok" neither on DBOutput nor XMLMap

Re: Get LastInsert ID for each rows in main

fdenis — Tue, 17 Jul 2018 08:39:16 GMT

on subjog OK are allowed only on first component of the subjob . (green background)

Re: Get LastInsert ID for each rows in main

Anonymous — Tue, 17 Jul 2018 10:26:26 GMT

If I do that I will lost the information I need in main flux

Re: Get LastInsert ID for each rows in main

fdenis — Tue, 17 Jul 2018 10:33:23 GMT

I do not think so. Try and sea.
Using lastInsertedId in an open transation alow you to use last Id as reference in an other Table.
if you have a complex insert procedure just Writ an SQL Procedure and call it from Talend.
by this way you can use this Insert Procedure manually or with an other soft.
Regards,