Date:         Wed, 7 Mar 2012 04:51:20 -0800
Reply-To:     drfg2008 <kontakt@datest.de>
Sender:       "SPSSX(r) Discussion" <SPSSX-L@LISTSERV.UGA.EDU>
From:         drfg2008 <kontakt@datest.de>
Subject:      Include file problem.
Content-Type: text/plain; charset=UTF-8

SPSS 20 (64bit)

Include file problem.

We try to start several SPSS/SQL-codes in different sps-programs
(Syntax-Files) from a central SPSS file.

The first GET DATA command deletes the old table in the database. The second
GET DATA command creates the new table. The two codes are integrated in one
SPSS-syntax file.

Now we have more than one tables to create.

Each syntax file (with two SQL-statements)  alone is working fine, unless it
is not started with ‘include file’. If, however, the program is started with
include file = '...'  from a central SPSS-syntax file, SPSS returns an error
and aborts.

> Warning on line 136th Command name: GET DATA
> SQLNumResultCols Failure

It seems that SPSS breaks off after clearing the table.


Here's the code (abridged)

--Filename: SPSS1000.sps --------------- *.

GET DATA
   / TYPE = ODBC
   / CONNECT = 'DSN = Data Bank;'
   / SQL = 'DROP TABLE This_Table;'
   / ASSUMEDSTRWIDTH = 255
CACHE.
EXECUTE.


GET DATA
   / TYPE = ODBC
   / CONNECT = 'DSN = Data Bank;'
   / SQL = 'CREATE TABLE This_Table

(...)

…..end of file …………………………


-----
Dr. Frank Gaeth
FU-Berlin

--
View this message in context: http://spssx-discussion.1045642.n5.nabble.com/Include-file-problem-tp5544019p5544019.html
Sent from the SPSSX Discussion mailing list archive at Nabble.com.

=====================
To manage your subscription to SPSSX-L, send a message to
LISTSERV@LISTSERV.UGA.EDU (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