Platforms

All platforms under which LISTSERV's DBMS features are supported.


Abstract

Used in conjunction with CHANGELOG_DBMS. Sets the DBMS table characteristics for mirroring changelog data to DBMS. This parameter is required to be set if CHANGELOG_DBMS is used.


Example

z/VM:

(not supported)

Unix:

CHANGELOG_DBMS_TABLE="CHANGELOG TIMESTAMP LISTNAME RECORDTYPE PARAMETERS" 

export CHANGELOG_DBMS_TABLE

Windows:

CHANGELOG_DBMS_TABLE=CHANGELOG TIMESTAMP LISTNAME RECORDTYPE PARAMETERS


Details

This setting contains five space-separated names:

      1. The name of the table in which to store changelog entries.
      2. The name of a time-stamp column in which to write the current date and time. This must be a DATE (Oracle), TIMESTAMP (DB2), DATETIME (SQL Server), or whatever else can store both date and time. This cannot be a character string.
      3. The name of a VARCHAR or equivalent column storing the name of the list. The maximum size depends on the list names you choose, but it should be at least 40.
      4. The name of a VARCHAR column storing the record type (BOUNCE, etc). This should probably be around 40.
      5. The name of a VARCHAR column storing the parameters. This ought to be 256 or so.

If any of these parameters is missing, the setting is ignored.


Default Value

Not set (null string).


See also

CHANGELOG_DBMS