Sql Query Not Returning Data In Spss 19.0.0.1 For Mac
Hi Lukas I was a little worried that this would be a little chatty. Follow Blog via Email Enter your email address to follow this blog and receive notifications of new posts by email. Canon printer driver updates windows 7.
Sql Query Not Returning Data In Spss 19.0.0.1 For Mac Os
How To Enter Data In Spss
Normally you'd access it via this Syntax: GET DATA /TYPE = - insert one of these types - ODBC,OLEDB,XLS,XLSX,XLSM,TXT Whichever is the type that you wish to access, you can also use SQL within the SPSS syntax editor. This is how I connect to my database from the syntax: GET DATA /TYPE=ODBC /CONNECT='DSN=MAVSQL;Description=SQL;UID=;APP=IBM SPSS Products: Statistics '+ 'Common;WSID=MAVNEW;DATABASE=Players;TrustedConnection=Yes' /SQL='SELECT Id, Faction, Active, Level, Name, Allignment, CurQuest, '+ 'PrevQuest, DeathCount, LastDeath, LastLogon, Created, Class, RacAB, '+ 'Comments, Test, Age, RealName, Email FROM dbo.DSOL' /ASSUMEDSTRWIDTH=255.
DATASET NAME DataSet1 WINDOW=FRONT. Hope that helps, I know the database I accessed is a SQL database but perhaps you can use the same methodology to access your IBM DB2 database.