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
Locked
