Where to store email addresses?

2480 pts.
Tags:
AS/400
i5
IBM iSeries
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
1

Answer Wiki

Thanks. We'll let you know when a new response is added.

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

Discuss This Question: 1  Reply

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.
  • WoodEngineer
    We find iNav an easy way to store a user's e-mail address with their user profile data. Open the user's profile, click Personal, then select the Mail tab.  Store the address in "SMTP name".
    As Bruce recommends, we just use an API to retrieve the e-mail address by the user profile.  
    A handy method is to wrap the API in a callable program.  In our case, only two parms - user profile and e-mail address.
    8,225 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

Thanks! We'll email you when relevant content is added and updated.

Following

Share this item with your network: