Question

Where to store email addresses

AS/400, iSeries, i5

We are looking for a place/table to store email addresses, they need to be associated with i5 User Profiles. They are going to be used in a Java Application.

The SMTP System Alias Table seems to be an appropriate place, but I have been unable to determine where this info is stored.

Does anyone know where the SMTP System Alias Table data is stored ?

Is there another table/file I should look at for storing email addresses ?

Thanks,
Bill

Bill,

There are various hints on the internet that the email addresses from the SMTP System Alias Table can be found in QUSRSYS/QATMSMTPA. It is not at all clear to me though if IBM supports a user directly accessing this file as it's purpose is not documented in the Information Center. The file is however externally described, so who knows.

The more traditional approach (which is clearly supported by IBM) is to use the System Distribution Directory (SDD) to store email addresses. This directory can be searched using the Search System Directory API QOKSCHD in order to obtain the email address. In addition you can also publish e-mail information using LDAP, etc when they are in the SDD. In order to convert addresses from the System Alias Table there is the Convert SMTP Names command CVTNAMSMTP.

Hope this helps,
Bruce Vining
http://www.brucevining.com/
Providing integrated solutions for the System i user community