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:
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.
Bookmarks