O'Reilly logo

SQL for eServer i5 and iSeries by Kevin Forsythe

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Chapter 7. Creating Functions

SQL includes a large number of built-in functions. These functions provide the ability to convert data types and modify column values in various ways. Those functions provided by SQL, however, do not always provide all the functions you might want to have. Every application has a few needs that are not always addressed by existing functions. For that reason, SQL provides the ability create user-defined functions. These functions can either be written in languages such as RPG, COBOL, C, and Java, or with SQL syntax.

Creating Functions with RPGLE

The Create Function statement allows developers to register subprocedures in RPGLE programs as SQL functions. Programmers who are more comfortable with RPGLE than SQL may prefer ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required