SQL Built-In Functions and Stored Procedures: The i5/iSeries Programmer's Guide

SQL Built-In Functions and Stored Procedures: The i5/iSeries Programmer's Guide

• Discover how to perform routine maintenance functions--such as copying a file or rebuilding an existing table without losing the data in the existing table
• Learn how to build data files-modify a library list-and compile programs
• Practice using example programs that not only teach but also make excellent additions to any programmer's library
• Learn how to use 11 different functions--including functions to edit numeric values for print with commas-decimal points-and currency symbols; a function that returns the distance in miles between two ZIP codes; functions to convert date and currency to a text string and more
• Gain access to complete code on the Web for each function so that you can use it directly in your own programs