DB_COUNTER_FIELD

For

Database Logger

Project

Purpose

To modify the name of the seq_num field that specified the record sequence number of each logged transaction in the following Database Logger Tables:

Alarm Management tables (ALARM_LOG and EVENT LOG)

Event Manager table (EM_LOG)

SPC tables

HDA tables

Tracker tables

Value

An up to 80 character name. The name may include or be entirely composed of uppercase characters (for example, SEQNUM) which is needed for certain database client applications that have problems accessing lowercase field names from an Oracle DMBS.

Note: When you use the DB_COUNTER_FIELD global parameter, make sure that you drop all affected tables before running the project. Otherwise, the Database Logger will not be able to recreate them with the new sequence number field name specified by the DB_COUNTER_FIELD global parameter.

Default Value

seq_num (as a lowercase string)

 

More information

Global parameters.