Re: SQL DECLARE CURSOR preference

First option is what I have used. Usually it's in a function that returns
Boolean value if it opened successfully. Same with reads from cursors


Sent from my iPhone

On Jun 24, 2014, at 2:19 PM, Gary Thompson <gthompson@xxxxxxxxxxx>

wrote:

I'm changing an existing program and noticed we have a variety of

"styles" for

where sql cursor declare statements are embedded:

1) "in line" in the subrtn/subproc where the cursor is opened

2) In *inzsr

3) On c specs just after the last d specs and prior to any

"business logic"

In the interest of trying to make a "shop standard" I'm welcoming

comments

Thanks!
--
This is the RPG programming on the IBM i (AS/400 and iSeries) (RPG400-L)

mailing list

To post a message email: RPG400-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/rpg400-l
or email: RPG400-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/rpg400-l.

--
This is the RPG programming on the IBM i (AS/400 and iSeries) (RPG400-L)
mailing list
To post a message email: RPG400-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/rpg400-l
or email: RPG400-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/rpg400-l.