SQL Stored Procedures
Sharon Hoffman
SQL Stored Procedures
A stored procedure is an SQL concept that's essentially equivalent to the iSeries idea of a called program.
Using stored procedures can improve SQL performance, particularly in networked environments, minimize code maintenance, and take advantage of existing iSeries code.
The iSeries supports two types of stored procedures: external stored procedures, which are written in languages such as RPG and COBOL, and SQL stored procedures, which are written in SQL.
Whichever type of stored procedure you use, it must be registered as a stored procedure before it can be called using SQL.
This session will includes generic stored procedure concepts and their iSeries-specific implementation, including the iSeries Navigator interface for registering stored procedures.
Sharon Hoffman began working with IBM midrange systems in 1981, and she is currently a senior technical editor for iSeries NEWS magazine. She focuses on emerging technologies such as Java and XML and is particularly interested in how these technologies integrate with existing iSeries applications. Her background includes extensive application development experience as a programmer, systems analyst, and consultant. She's also been involved with IT education for more than 20 years as an instructor, writer, and editor and is currently teaching several online e-learning classes. Sharon is a regular speaker at COMMON and other industry events.