Re: Generic trigger - Dinamically field position find

Also you can add a field:

FH_ULT_MOD TIMESTAMP NOT NULL GENERATED ALWAYS FOR EACH ROW
ON UPDATE AS ROW CHANGE TIMESTAMP,

It will have the time stamp of the last update.


On 11/28/2016 12:54 PM, Barbara Morris wrote:

On 11/28/2016 9:42 AM, gio.cot wrote:

I would need write a generic trigger program that update date and time
change fields ;
...

As the date and time change fields , are always the same, (example
DATA_LOG - TIME_LOG), I would need find the initial field position in input
record update the values in the input record string with substring and then
return back so that in record I will find my date and time updated.

First, use the input-buffer offset in the trigger parameter to get a pointer to the input buffer.

Then use the QUSLFLD API to find the position of the two fields in the input buffer.

-- Este e-mail fue enviado desde el Mail Server del diario ABC Color -- -- Verificado por Anti-Virus Corporativo Symantec --