Re: Getting SP error making progress

Vernon,

If that's there are differences in SPROCS for DB2/400 compared to the other
DB2 flavors, then you have a point, and I'm giving bad advice based on my
ignorance.

There is a dearth of IBMi advice on dba.stackexchange.com, and questions
take a while to get answered, Serverfault is a little better for operations
stuff. I generally do like to put more black and white questions on
stackexchange (on any computing platform) because the answers can evolve
into good canonical questions with lots of commentary, and the SEO is
better than mailing list archives so more people learn from my question in
the future..


Justin

On Thu, Jun 4, 2015 at 5:34 PM Vernon Hamberg <vhamberg@xxxxxxxxxxxxxxx>
wrote:

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.

--
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.