Re: Got this error when running SPSS 20

Posted by Richard Ristow on Dec 10, 2014; 11:30pm
URL: http://spssx-discussion.165.s1.nabble.com/Got-this-error-when-running-SPSS-20-tp5728108p5728150.html

At 07:38 AM 12/4/2014, albert_sun wrote:

>>SQLFetch (getting tables) failed :[Microsoft][ODBC Microsoft Access
>>Driver] The query cannot be completed. Either the size of the query
>>result is larger than the maximum size of a database (2 GB), or
>>there is not enough temporary
>>storage space on the disk to store the query result.
>
>Any idea how to overcome this? This appears when I did var to case
>transformation.

How are you reading your data? With a GET DATA/TYPE=ODBC?

If so, try a CACHE command between the GET DATA and the VARSTOCASES.

=====================
To manage your subscription to SPSSX-L, send a message to
[hidden email] (not to SPSSX-L), with no body text except the
command. To leave the list, send the command
SIGNOFF SPSSX-L
For a list of commands to manage subscriptions, send the command
INFO REFCARD