I am trying to figure out how to translate names stored in an AS/400 table called Clients(ID, FNAME, MNAME,LNAME,…) into foreign languages. The first attempt is doing that into Arabic. So the DB admin created a dictionary table with 2 columns ARABDICT(ENGNAME,ARBNAME). He did not create a primary key in order to join the tables.

I am using this query and it is not returning anything, it once gave me Correlation without qualification occurred for column FNAME to table Clients and then no errors are even returned.

SELECT fname, a.arbname
FROM QS36F.Clients, QS36F.ARABDICT a
WHERE a.arbname = (SELECT arbname FROM QS36F.Clients c, QS36F.ARABDICT WHERE c.FNAME LIKE ‘%engname%’ )