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?
2 REPLIES
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.