DSXchange

I am getting following error

SQLAllocHandle: Failed to allocate environment handle 'ENV'.

when reading from db2 table

my query looks
SELECT column list....
FROM #Environmnet variable#Table A E, #Environmnet variable#Table B I
WHERE condition;

Could you explain the actual variable name and value at runtime, since the spelling of

#Environmnet variable#

doesn't look quite right?

Failed to allocate environment handle is typically indicative of one of two things - that the server does not have enough memory to undertake setting up an ODBC environment, or that the ODBC driver manager could not be found. These, therefore, should be the first areas that you investigate.