Field help (ALOBDDID)

This code identifies the session open in the database. Depending on the databases, it is obtained in different ways:

• it is the SESSIONID environment value under Oracle, obtained via a query of type:

select userenv('SESSIONID') From dual

• it is the @@spid variable under Sql server.

It identifies in a unique fashion a connection to a database, and it is namely used to make the link between an update and the user code in the triggers created via the audit tab in the table dictionary.