SQL Built-In Functions and Stored Procedures

An introduction to creating and using SQL functions and stored procedures under OS/400 and i5/OS, this book explains how each is used and explores some of the stored procedures and functions included with SQL on the iSeries as part of OS/400. Programmers are lead through the development of custom-built functions for the programmer's own use, which includes editing numeric values for print with commas, decimal points, and currency symbols; returning the distance in miles between two zip codes; returning a running cumulative total for the data in the column; and converting date and currency to a text string. Each function includes code that can be used in the developer's own programs.