Better support for local host variables might come first, before local
cursor declaration.
... but local variable support for embedded SQL is already realized with
release 6.1.
With V6.1 support of "local" files, is it reasonable to expect future
support for "local" cursors ?.
... aren't local cursors already supported or do I misunderstand what you
want?
I'm using cursors in different procedures within the same member quite often
(without any problems).
Even though I have to compile everything for V5R2 (because of some of our
clients still use V5R2).
The only prerequisite is, the cursor names (and when release V5R3 was
introduced) the host variable names must be unique within the module.
If the host variable names are unique within a member you can define and
used them the locally even before release 6.1.
As for passing cursors as parameters, why not registering the local
procedure as SQL Stored Procedure with a returning result set.
Beginning with Release 7.1 result sets can be handled with embedded SQL.
Mit freundlichen Grüßen / Best regards
Birgitta Hauser
"Shoot for the moon, even if you miss, you'll land among the stars." (Les
Brown)
"If you think education is expensive, try ignorance." (Derek Bok)
"What is worse than training your staff and losing them? Not training them
and keeping them!"
-----Ursprüngliche Nachricht-----
Von: rpg400-l-bounces@xxxxxxxxxxxx [mailto:rpg400-l-bounces@xxxxxxxxxxxx] Im
Auftrag von darren@xxxxxxxxx
Gesendet: Friday, 21. October 2011 14:34
An: RPG programming on the IBM i / System i
Betreff: Re: SQLRPGLE cursor questions
It might be reasonable to want such a thing, but I can't say whether its
reasonable to expect it. Better support for local host variables might
come first, before local cursor declaration.
From: Gary Thompson <GThompson@xxxxxxxxxxx>
To: rpg400-l@xxxxxxxxxxxx
Date: 10/20/2011 02:15 PM
Subject: SQLRPGLE cursor questions
Sent by: rpg400-l-bounces@xxxxxxxxxxxx
With V6.1 support of "local" files, is it reasonable to expect
future support for "local" cursors ?.
And, if not, why not ?
--
This is the RPG programming on the IBM i / System i (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.
midrange.com
