Clearly there is more to your SAS program flow that you are sharing - it would be best to COPY/PASTE the SAS log output (including any code leading up to the PROC SQL invocation), otherwise the debugging assistance process for forum subscribers will be a guessing-game as to what additional code you have and what SAS diagnostic messages you are receiving.
Using the system options SASTRACE and SASTRACELOC could be essential, since they will show you the exact SQL syntax that is performed by DB2.
If you are in ZOS, there are a bulk of other DB2 specific options you can play with to get more information about your SQL.
From this bit of the log you are submitting the second querry :
FROM TB926 A,
WHERE A.EID = B.EID
as a passthru. This means that it is actually being processed by the DB2 instance not SAS. Thus it is looking for TEMP in DB2 where it does not exist. It is DB2 adding your user name to TEMP which gives this away. You will need to assign a libname to DB2 and run this querry in SAS not a passthru to get the resluts you desire.