Stored Procedures, help
We are trying to write some very simple stored procedures using DB-ACCESS.
Versions
cat $INFORMIXDIR/etc/*-cr
INFORMIX-4GL Interactive Debugger Version 6.05.UC1
Copyright (C) 1984-1995 Informix Software, Inc.
INFORMIX-4GL Version 6.05.UC1
Copyright (C) 1984-1995 Informix Software, Inc.
INFORMIX-4GL Rapid Development System Version 6.05.UC1
Copyright (C) 1984-1995 Informix Software, Inc.
INFORMIX-SQL Version 6.05.UC1
Copyright (C) 1984-1995 Informix Software, Inc.
INFORMIX-OnLine Dynamic Server Version 7.24.UC5
Copyright (C) 1986-1998 Informix Software, Inc.
Procedure
CREATE PROCEDURE ex_cont_ex()
DEFINE i,s,j INT;
FOR j = 1 TO 20
IF j > 10 THEN
CONTINUE FOR;
END IF
LET i,s = j,0;
WHILE i > 0
LET i = i - 1;
IF i = 5 THEN
EXIT FOR;
END IF
END WHILE
END FOR
END PROCEDURE
The above procedure is straight from the manual but I still get a syntax
error at the DEFINE statement. I know we're missing something obvious but I
don't know what it is :o( We're new to SPL. For all I know we don't
actually have it! Although I take the manual to say that its included with
Db-Access.
Thanks
Tony Flaherty.
Analyst Programmer
Misys Financial Systems
Change at to @ to reply by email