Date:         Tue, 3 Apr 2012 01:14:54 -0700
Reply-To:     SD <silvitsch@gmx.de>
Sender:       "SPSSX(r) Discussion" <SPSSX-L@LISTSERV.UGA.EDU>
From:         SD <silvitsch@gmx.de>
Subject:      Integration of MySQL Procedure
Content-Type: text/plain; charset=us-ascii

Hi,

I'm trying to integrate some MySQL-Code into SPSS.
In general, it works. But I have problems with integrating the following
SQL-Code:

DELIMITER $$
CREATE Procedure `test`()
BEGIN
  create table abc(
  a int
  );
  SET @i=0;
  while(@i<=100)
  do
    insert abc(a) values (@i);
    Set @i=@i+1;
  end while;
END $$

(I know I don't need a procedure for the code above. I have simplified the
original code.)

If I try to integrate it with

GET DATA
  /TYPE=ODBC
  /CONNECT=' DSN=myDB;'
  /SQL=' DELIMITER $$ '+
' CREATE Procedure test() '+
' BEGIN '+
' create table abc( '+
' a int '+
'   ); '+
'   SET @i=0; '+
'   while(@i<=100) '+
'   do '+
'     insert abc(a) values (@i); '+
'     Set @i=@i+1; '+
'   end while; '+
' END $$ '+
 /ASSUMEDSTRWIDTH=255.
CACHE.
EXECUTE.

SPSS says, that there is some Syntax-Error in my SQL-Code, but running the
code (not with SPSS) works.

Thank you in advance.
SD


--
View this message in context: http://spssx-discussion.1045642.n5.nabble.com/Integration-of-MySQL-Procedure-tp5614496p5614496.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