Hi iSeries buffs !
I have a table - F983051 - with the following columns in it :
as well as a bunch of other columns that are not important.
I have another, custom table, F55983ADT which contains the following information :
Now, I want to create a TRIGGER that inserts data into the F55983ADT table whenever the F983051 is READ. Obviously the values VRPID, VRVERS, VRENHV would come from the row selected from the F55983ADT table - but the USER, DATE and TIME would be system provided values based on the connection.
I will gift additional points to a very in-depth and conclusive answer. Thankyou !