Hello,

I've done some research on the internet but I wasn't able to find an answer and frankly I am quite sure that there is no possibility to do it.

I have a lot of apps, built in Excel, that are getting data from various DB2 tables and transfer them in excel, using an ADODB connection.
The code looks like that:

Please Login or Register  to view this content.
The problem is that sometimes, not always, I receive an [DB2] SQL0905N ASUTIME error which means that the complexity of the SQL script exceeds the resources allocated for that table (or at least something like that I understand).

ps.jpg

Knowing that I can't have access to the DBA tables to change that ASUTIME parameter, there is any optimization that I can do to the VBA code in order to avoid this error?
There is another type of connection that I can use to access the tables, other than the ADODB?

Thank you!
Cheers,
A.B.