MySQL Error message in SPSS

classic Classic list List threaded Threaded
2 messages Options
Reply | Threaded
Open this post in threaded view
|

MySQL Error message in SPSS

drfg2008
SPSS 20 Win 64bit

when starting a MySQL Code to delete a table on the server I get the following error message. However, everything works fine.

Does it mean that the program has to be changed? How can one avoid the error message?


>Warning.  Command name: GET DATA
>SQLNumResultCols Failure


Thanks



Dr. Frank Gaeth

Reply | Threaded
Open this post in threaded view
|

Re: MySQL Error message in SPSS

drfg2008
This is the code:

GET DATA
  /TYPE=ODBC
  /CONNECT='DSN=Database Datenbank;'
  /SQL='DROP TABLE IF EXISTS TableName;'
  /ASSUMEDSTRWIDTH=255.
CACHE.
EXECUTE.


This is the error message

>Warning.  Command name: GET DATA
>SQLNumResultCols Failure

>Error # 105.  Command name: EXECUTE
>This command is not valid before a working file has been defined.
>Execution of this command stops.


It always produces these error messages, however, it works if the program is started as an sps File, but it does not work when started from a spj File (Production Mode).
Dr. Frank Gaeth