LISTSERV 17.5 Help - DBMS Keyword

DBMS Keyword

DBMS= No
DBMS= Yes[,Table(xxx)][,Email(xxx)][,Name(xxx)][,Uemail(xxx)][,Options(xxx)] [,Server(server_alias)]

This keyword is not available in LISTSERV Lite.

This keyword is used to tell LISTSERV that the list of subscribers is kept in an ODBC or OCI database rather than in the traditional *.LIST file. In order to set this keyword to anything but the default, DBMS support must be installed on the LISTSERV server. Please see the LISTSERV Advanced Topics Manual for more information on installing support for and using the DBMS and Mail-Merge functions.

Warning: List owners should not add this keyword to their list header as the use of the "DBMS=" keyword presupposes existing DBMS support that has been configured to work with LISTSERV. Further, list owners should not change the value of this keyword if it exists in their list header, as changing any of the parameters could lead to unexpected results.

When migrating an existing list to use a DBMS, you are responsible for migrating the subscriber data to the DBMS, if necessary (in many cases, the subscriber data will already be in the DBMS, possibly in a slightly different format). Once you add the "DBMS= Yes" keyword, LISTSERV stops accessing subscriber data from the xxx.LIST file and uses the DBMS instead.

The default is "DBMS= No", i.e., keep subscriber information in a traditional *.LIST file.

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.