Re: New "Stored Procedures" Redbooks

Looks like the External book has a few changes, but they reference
v5rX...not 6.1 or 7.x

"New information
This publication includes several of the announced features for procedures,
triggers, and
UDFs in V5R1, V5R2, V5R3, and V5R4. This book includes suggestions,
guidelines, and
practical examples about how to effectively develop IBM DB2 for i
procedures, triggers, and
UDFs. The following topics are covered in this book:
External stored procedures and triggers
Java procedures (both Java Database Connectivity (JDBC) and Structured Query
Language for Java (SQLJ))
External triggers
External UDFs
This publication also offers examples that were developed in several
programming languages,
including RPG, COBOL, C, Java, and Visual Basic, by using native and SQL
data access
interfaces."

The SQL Book mentions newer releases
"IBM® DB2® for i supported these features for many years, and they are
enhanced in IBM i versions 6.1, 7.1, and 7.2."

I'm guessing part of the reason for the split is that the SQL book is
subject to more changes than the external book.

Charles


On Fri, Jun 17, 2016 at 10:01 AM, Justin Dearing <zippy1981@xxxxxxxxx>
wrote:

Can't wait to read that. The old book was good, but dated. I hope they
mention the modern tooling.

On Fri, Jun 17, 2016, 09:39 Charles Wilt <charles.wilt@xxxxxxxxx> wrote:

All,

Just happened to run across this today.
"External Procedures, Triggers, and User-Defined Functions on IBM DB2 for
i"
https://www.redbooks.ibm.com/abstracts/sg246503.html?Open

Published April 2016.

Looks like the split the original book into two.
"This book is part of the original IBM Redbooks publication, Stored
Procedures, Triggers, and
User-Defined Functions on DB2 Universal Database for iSeries,

SG24-6503-02,

that covered
external procedures, triggers, and functions and also SQL procedures,
triggers, and
functions. All of the information that relates to external routines was
left in this publication. All
of the information that relates to SQL routines was rewritten and

updated.

It is in the new IBM
Redbooks publication, SQL Procedures, Triggers, and Functions on DB2 for

i,

SG24-8326."

"SQL Procedures, Triggers, and Functions on IBM DB2 for i"
https://www.redbooks.ibm.com/abstracts/sg248326.html?Open

Also published April 2016.

I don't see any posts to the list about it, so thought I'd pass it along.

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

Please contact support@xxxxxxxxxxxx for any subscription related
questions.

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

Please contact support@xxxxxxxxxxxx for any subscription related
questions.