topic Re: Informix get last inserted serial in Talend Studio

Informix get last inserted serial

Anonymous — Fri, 14 Aug 2015 02:57:37 GMT

I am working on a project that has to insert a row in an informix db and send an API call then go back and update the informix dB so I need the serial id field after I do the insert to use to update the row later. I noticed there are components for other type dB that do this but not for informx. This is also not an uncommon task so how this done in talend?

Re: Informix get last inserted serial

Anonymous — Fri, 14 Aug 2015 17:44:07 GMT

here is a screen shot of the job

Re: Informix get last inserted serial

Anonymous — Wed, 19 Aug 2015 15:58:35 GMT

I couldn't resolve the problem with Talend so i ended up solving it with Java. I used a tjavarow and wrote the code to run the query to get the last inserted serial field.