Good afternoon everybody
I access SQL data with the following command
GET DATA
/TYPE=ODBC
/CONNECT='DSN=BI_dw;'
/SQL='select * '+
'from DW.vfyr'
/ASSUMEDSTRWIDTH=1000.
CACHE.
EXECUTE.
DATASET NAME SWvfyr WINDOW=FRONT.
When doing so I typically encounter two issues:
1. I always get an error message
>Warning. Command name: EXECUTE
>SQLFetch (getting tables) failed :[MySQL][ODBC 5.1
Driver][mysqld-5.0.81-community-nt-log]
The data look fine so I am not sure I understand what the error message
actually means.
2. We have an ID variable that causes some problem when I use SPSS to read
in (values are read in with some random numbers - instead of ID = 48 it will
display 4808989). I end up having to specify this variable ("CONVERT(ID,
decimal) as ID") which is a workaround but I would love to have a solution
how I could adjust the settings so I could also use the wildcard.
Any advice is greatly appreciated
=====================
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
