Re: Getting SP error making progress

[Vernon Hamberg <vhamberg@xxxxxxxxxxxxxxx>]

Justin

Do you really find stackflow good for IBM i SQL? Especially with regards 
to stored procedures, there are things that are specific to IBM i that 
might not be discussed there - unless you find one of us replying.

StFl is great, and I have learned a lot from more general SQL resource - 
just hoping to avoid confusion for someone kind of new to this stuff.

Regards
Vern

On 6/4/2015 3:17 PM, Justin Dearing wrote:
> Hello,
>
> While there is a lot of DB2 knowledge here, you might find
> http://dba.stackexchange.com a better source for SQL syntax questions.
>
> Justin
>
> On Thu, Jun 4, 2015 at 3:07 PM Hoteltravelfundotcom <
> hoteltravelfun@xxxxxxxxx> wrote:
>
> > OK now trying SP but getting error, what is the syntax  I am off?
> >
> > CREATE PROCEDURE rlib.spclspaytp()
> > BEGIN
> >     DECLARE CURSOR_ CURSOR WITH RETURN FOR
> >      SELECT * FROM ASTDTA.REFERRF;
> >      OPEN CURSOR_;
> > END
> >
> >
> > SQL0104 - Token <END-OF-STATEMENT> was not valid. Valid tokens: ;.
> >
> > SQL0084 - SQL statement not allowed.
> > SQL0104 - Token <END-OF-STATEMENT> was not valid. Valid tokens: DECLARE.
> > --
> > This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
> > To post a message email: MIDRANGE-L@xxxxxxxxxxxx
> > To subscribe, unsubscribe, or change list options,
> > visit: http://lists.midrange.com/mailman/listinfo/midrange-l
> > or email: MIDRANGE-L-request@xxxxxxxxxxxx
> > Before posting, please take a moment to review the archives
> > at http://archive.midrange.com/midrange-l.