I am trying to use this update statement in order to fill a column Name in a table called MD001 from a table called Patient

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 have the SQLRPGLE code below showing my access and close – yet after the program runs the files (MONEWAS3 and WELFARE) stay open as verified by looking at “Display Open Files” for the session. If I sign off and sign back on they obviously close, but running the program again will open and leave them open.

Given two tables, i want to match values at certain position of the string in table two so that i can see how many produce does one student have: