I've created two DB views (F5595921 & F550092) & used them in some APPL (makes it easier to output your grid to Excel, if necessary).
It was the only way to add multiple instances of the same table (F0101), and join multiple tables from multiple databases.
CREATE VIEW PRODDTA.F5595921
AS
SELECT PRODDTA.F550092.USFRROLE AS RLFRROLE, PRODDTA.F550092.USEUSER AS RLEUSER, PRODDTA.F550092.USAN8 AS RLAN8,
F0101_1.ABALPH AS RLALPH, F0101_1.ABAC27 AS RLAC27, F0101_1.ABAC28 AS RLAC28, PRODDTA.F550092.USTOROLE AS RLTOROLE, PRODDTA.F550092.USAN80 AS RLAN80, F0101_2.ABALPH AS RLMLNM, F0101_2.ABAC01 AS RLAC01
FROM PRODDTA.F550092 LEFT OUTER JOIN
PRODDTA.F0101 F0101_2 ON PRODDTA.F550092.USAN80 = F0101_2.ABAN8 LEFT OUTER JOIN
PRODDTA.F0101 F0101_1 ON PRODDTA.F550092.USAN8 = F0101_1.ABAN8
and:
CREATE VIEW PRODDTA.F550092
AS
SELECT F95921_1.RLFRROLE AS USFRROLE, F98OWSEC_1.SCEUSER AS USEUSER, F0092_1.ULAN8 AS USAN8, F0092_2.ULUSER AS USTOROLE,
F0092_2.ULAN8 AS USAN80
FROM PS810.SY810.F98OWSEC F98OWSEC_1 RIGHT OUTER JOIN
PS810.SY810.F0092 F0092_2 ON F98OWSEC_1.SCUSER = F0092_2.ULUSER LEFT OUTER JOIN
PS810.SY810.F95921 F95921_1 LEFT OUTER JOIN
PS810.SY810.F0092 F0092_1 ON F95921_1.RLFRROLE = F0092_1.ULUSER ON F0092_2.ULUSER = F95921_1.RLTOROLE