https://community.qlik.com/t5/Talend-Studio/tDBoutput-postgreSQL-get-ID-of-inserted-row/m-p/2241440#M28591 <P>Hello,</P> <P>&nbsp;</P> <P>&nbsp;i would like to know what is the best practise to get ID of inserted row using tDBoutput. (IDs are generated automatically by database sequencer)</P> <P>&nbsp;</P> <P>At start i was using tDBinput to get last value from sequencer with query: "select last_value from my_sequencer ", but this is only working when i have 1 or small number of jobs running at the same time.</P> <P>&nbsp;</P> <P>Any help is much appreciated.</P> Sat, 16 Nov 2024 02:01:17 GMT michaelh1 2024-11-16T02:01:17Z https://community.qlik.com/t5/Talend-Studio/tDBoutput-postgreSQL-get-ID-of-inserted-row/m-p/2241440#M28591 <P>Hello,</P> <P>&nbsp;</P> <P>&nbsp;i would like to know what is the best practise to get ID of inserted row using tDBoutput. (IDs are generated automatically by database sequencer)</P> <P>&nbsp;</P> <P>At start i was using tDBinput to get last value from sequencer with query: "select last_value from my_sequencer ", but this is only working when i have 1 or small number of jobs running at the same time.</P> <P>&nbsp;</P> <P>Any help is much appreciated.</P> Sat, 16 Nov 2024 02:01:17 GMT https://community.qlik.com/t5/Talend-Studio/tDBoutput-postgreSQL-get-ID-of-inserted-row/m-p/2241440#M28591 michaelh1 2024-11-16T02:01:17Z