DAL: Out-of-memory Error Due to Application‘s List of Tables



I'm evaluating DAL on an IBM 3090. I would like to hard code the name of
a specific table within a query. Is there a way to avoid maintaining
a list of tables in memory that causes an out-of-memory error due to the
large list of tables available?

I've been able to use the Excel add-in to do the following tasks:

- Connect to the mainframe
- Access the DAL server
- Open sqlds
- Open the iu database

At this point, the Excel data access add-in appears to be creating
a local copy of information about all the tables within the iu database on
the mainframe. Why is this necessary? Since the combination of the
system, the Finder, and Excel use up about 3.4MB of the 4MB available on
our Macintosh IIci 4/80, I get an out-of-memory message box with an OK
button.

ClearAccess actually does the same sort of thing. When creating a new
query, it fills one component of the query-building window with a scroll
box containing all the tables that I have in my view of the iu database.
Since I'm running only a desk accessory, there is enough memory for this
to happen.

DAL engineering confirmed that this is an application implementation
problem, not a DAL problem. DAL doesn't require a list of tables
kept locally on the workstation.

We recommend that you discuss this issue with the application vendors.

You can find contact information for the various vendors by clicking the
Library Index button to view the folder structure in the Tech Info
Library. An alphabetic listing of vendors is in the Third Party
Company Directory folder.


Published Date: Feb 18, 2012