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

Bücher

Angebote / Angebote:

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.