SMTPHOST

This table maintains a list of SMTP servers where HCL 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.
OPTCOUNTERSMALLINT NOT NULL DEFAULT 0The 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