How to query a Maximo domain with SQL?

Question

I have a domain in Maximo 7.6.1.1 called DIVISIONS.

---

---

I would like to write a SELECT statement that queries the DIVISIONS domain to get the VALUE and DESCRIPTION fields.

The query would be made into a view; to be used in a separate database via a dblink.

How can I query a Maximo domain with SQL?

Answer 1

I can query the ALNDOMAIN table (ALN stands for alphanumeric):

select
    *
from
    alndomain
where
    domainid = 'DIVISIONS'

---

For what it's worth, there is also a parent domain table (for lack of a better word).

select
    *
from
    maxdomain
where
    domainid = 'DIVISIONS'