Thanx Woody. That was the problem. It compiles fine now.

On Thu, Apr 5, 2012 at 4:02 PM, Woody <woody-tmw@...> wrote:

> **
>
>
> From: "Mags Phangisa" <magutywa@...>
>
> > 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.
>
> Did you set the terminator to something other than semi-colon (;) first?
>
> SET TERM ^;
>
> CREATE PROCEDURE ...
> ...
> END^
>
> SET TERM ;^
>
> Woody (TMW)
>
>
>


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