SMTPHOST

This table maintains a list of SMTP servers where WebSphere Commerce has successfully connected to in the past. Any entries in this table should represent a valid SMTP server name and port pair.

Column Descriptions:

NameTypeDescription
HOSTVARCHAR (250) NOT NULLHost name of the SMTP host.
PORTINTEGER NOT NULLPort number of the SMTP host.
OPTCOUNTERSMALLINTThe optimistic concurrency control counter for the table. Every time there is an update to the table, the counter is incremented.

Indexes:

NameColumn NamesType
<SYSTEM-GENERATED>HOST+PORTPrimary Key