RE: SQL DECLARE CURSOR preference

Appreciate your thoughts, but unsure about "variant 3": is
that referring to Pascal/Object Pascal ?


-----Original Message-----
From: RPG400-L [mailto:rpg400-l-bounces@xxxxxxxxxxxx] On Behalf Of D*B
Sent: Tuesday, June 24, 2014 11:47 PM
To: RPG programming on the IBM i / System i
Subject: Re: SQL DECLARE CURSOR preference

first of all: I don't use SR since procedure came up.
In most cases open and fetch are in diffrent procedures, so the declaration should be global, it's better for readability (and the SQL compiler anyway).
Good old Pascal style says: all declarations at the beginning of it's block => variant 3 is best choice.

Dieter

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