Loading…
COMMON Fall Conference & Expo | October 15-17 | Pittsburgh, PA | www.common.org/fall
Monday, October 15 • 4:00pm - 5:00pm
17AA SQL Stored Procedures and Application Modernization

Log in to save this to your schedule and see who's attending!

Among the many modernization technologies available on IBM i, SQL is perhaps the one best known by RPG developers. This session won't focus on how to write SQL statements, but rather how to write scripts that combine SQL statements together into procedures that encapsulate database access and core business logic for use in a myriad of modern applications. We'll discuss how stored procedures fit into a modernization strategy, and why they are such a good fit for RPG programmers who want to participate in modernization projects. They're also a great fit for anyone new to IBM I who needs access to its database for applications in PHP, Java, Crystal Reports, IBM Web Query, Excel, Web Services, conversion projects, etc. SQL is often embedded in other languages, such as RPG, PHP, Java, etc. But IBM provides the SQL Procedure Language (SQL/PL), which can be used to code complex or multiple SQL statements into procedures that can form the backbone of a service oriented architecture. These procedures can be called from any programming language. This can simplify the database access code in PHP, Java, and other host languages, while taking full advantage of DB2-specific SQL features. Come and learn about the many features and benefits of SQL stored procedures, how to code them, and how to use them in your modernization strategy.


This is Session ID:170074

Speakers
avatar for John Valance

John Valance

Senior Consultant, Profound Logic
John Valance is a senior consultant and modernization strategist for Profound Logic Software. He has worked on the IBM midrange platform since the 1980s, and on web development since 1998. As a consultant and developer, John specializes in modernization and web application development... Read More →


Monday October 15, 2018 4:00pm - 5:00pm
City Center A