I want to get the id of the row inserted into a database by a transaction group. Is this possible?
Is the data going into a table where data is being inserted by the transaction group and by some other means?
There is multiple transaction groups inserting data into this table. Every hour, each area (currently three) with their own transaction group, inserts one row into this table.
You could try adding a column to the table and then pushing in the Transaction Group Name (or whatever you want) when the transaction group executes.
I understand that will give me the option of selecting rows by transaction group but I want to get the index number generated by the insert command. I know this can be done with a script but I was wondering if I could do it within a transaction group.
I’ve the same requirement.
Did you get any method to do this?
tim