Storing a dataset in a resident table

[Anonymous]

Hi,

I am doing a LOAD statement which produces a large dataset; I want to store that dataset for use in a second tab in the load script, but I don't want to store the dataset as a "physical" QVD, such as

STORE

                    RATINGS

INTO

(qvd);

Is it possible to somehow store this dataset in memory, i.e., a resident table? I tried this:

STORE

     RATINGS

INTO

     RATINGS_TABLE (qvd);

But the subsequent LOAD in the second tab failed ("Table not found").

Is the only way to make a previously-loaded dataset available for future use to store it as a physical QVD on the filesystem?

Many thanks,

VB

[jonathandienst]

Hi

I don't quite understand your question. Storing to a qvd is for file storage. All the tables loaded into the model are in memory and available to the script after the LOAD statement, accessible with a LOAD ... RESIDENT.

To use LOAD ... RESIDENT, it is necessary to name the tables, like:

TableName:

LOAD ...

and then use later with

AnotherTable:

LOAD ID, Name, Description RESIDENT TableName;

Not sure if I answered your question though....

Jonathan