Loading…
Attending this event?
Experience the magic of education. 
Monday, May 20 • 9:15am - 10:15am
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.

Speakers
avatar for John Valance

John Valance

President & CTO, Division 1 Systems
John Valance has worked on the IBM midrange platform since 1983 and on web development since 1998. As a consultant and developer, John specializes in database and web application development on the IBM i platform. He is also a trainer for Zend Technologies, teaching PHP Foundations... Read More →


Monday May 20, 2019 9:15am - 10:15am
Fantasy Tower Magic Kingdom 4

Twitter Feed