CHANGELOG_DBMS_TABLE

This configuration variable is used in conjunction with CHANGELOG_DBMS. It sets the DBMS table characteristics for mirroring changelog data to DBMS. This parameter is required to be set if CHANGELOG_DBMS is used.

CHANGELOG_DBMS_TABLE=CHANGELOG TIMESTAMP LISTNAME RECORDTYPE PARAMETERS

This configuration variable 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 be about 40.
  5. The name of a VARCHAR column storing the parameters. This ought to be about 256.

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



LISTSERV® is L-Soft's email list management software, originally developed by Eric Thomas in 1986. Visit the LISTSERV® Resource Center for more complete documentation.

LISTSERV® is a registered trademark. The trademark identifies LISTSERV® as a brand of email list management software developed by L-Soft.