Re: Learning about SQL Stored Procedures

[Alan Campin <alan0307d@xxxxxxxxx>]

Yes, you can write in SQL or in RPG or really any language. Best is
RPG Service Program. Fastest. AIX and iSeries both compile SQL to C
code. Biggest problem I have had with SQL based procedures is IBM
breaking them. Went for 3 months once when IBM broke the compiler with
new release.


On Tue, May 8, 2012 at 12:52 PM, Richard Casey <casey_r@xxxxxxxxxxxxxxxx> wrote:
> Check out the IBM Redbook at
> http://www.redbooks.ibm.com/abstracts/sg246503.html
>
> Published in 2006 so there may be more current features that aren't covered.
>
> And yes, stored procedures can be written in pure SQL or in other languages:
> RPG, COBOL, Java, C.
>
> Have fun!
> Richard
>
>
>
> -----Original Message-----
> From: midrange-l-bounces@xxxxxxxxxxxx
> [mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of James Lampert
> Sent: Tuesday, May 08, 2012 2:39 PM
> To: Midrange Systems Technical Discussion
> Subject: Learning about SQL Stored Procedures
>
> Where's the best place to start learning about Stored Procedures?
>
> Especially in terms of knowing what's specific to "i," what's specific
> to AIX on "p," and what applies to both.
>
> I understand that they can be implemented both in pure SQL, and in HLLs;
> is that correct?
>
> --
> JHHL
>
> --
> 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.