Hi everyone,

The following stored procedure won't compile successfully:

CREATE PROCEDURE SPS_PYMT (SDT Date, EDT Date)
RETURNS
(MBR DATE, POL VARCHAR(20), PTY CHAR(4), BNK DATE, AMU DECIMAL(10,2), ERR
CHAR(4))
AS
BEGIN
FOR
SELECT MBRID, POLNO, PTYPE, BNKDT, AMUNT, ERROR
from PYMT where BNKDT>=:SDT and BNKDT<=:EDT
INTO :MBR, :POL, :PTY, :BNK, :AMU, :ERR
DO
SUSPEND;
END

It brings up the following error:
Unexpected end of command - line 11, column 3

Line 11 is where SUSPEND is.

I gather it is something small that brings up the error but I just can't
find it. Pls assist.

Mags


[Non-text portions of this message have been removed]