how to capture session information in a table ? 1

[vikind]

Hi,
every time i run a workflow i want to populate a table that contains information
as shown in the AUDIT TABLE below:

how can we capture this information for each session or workflow and populate this table.
also the SKEY has to be a sequence value.

AUDIT TABLE
----------

WORKFLOW_NAME | INSERTED | UPDATED | DELETED | ERRORS |

RUNTIME | SESSION_NAME | SKEY




thanx

 

[blom0344]

Do not know about version 6, but in version 5 all this information is available in the repository tables, like:

OPB_SESSION_LOG

You should take a better look into the repository to see what treasures it harbors........

T. Blom
Information analyst
tbl@shimano-eu.com