Informix get last inserted serial

One Star

Informix get last inserted serial

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?
One Star

Re: Informix get last inserted serial

here is a screen shot of the job
One Star

Re: Informix get last inserted serial

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.