SQL/400: A Professional Programmer's Guide

Overview

If you're a programmer or user working with relational database management systems in the AS/400 midrange environment, this book offers you a surefire guide to SQL, with a specific focus on the AS/400 DB2/400 dialect. Using a proven tutorial format, this essential reference takes you step by step through SQL tasks that deal with the retrieval and manipulation of data in relational databases. You'll find expert coverage of a wide range of crucial SQL topics, including: selecting data from a single table; using built-in functions; defining and manipulating data; accessing multiple tables; creating tables, indexes, and views. This practical sourcebook also features a wealth of material on other SQL/400 topics, such as the view concept, database security, transaction processing, the DB2/400 catalog, and the role of SQL in a client/server system. Filled with hundreds of SQL code segments, this unique productivity tool will give you the hands-on information and guidance needed to make the most of the powerful AS/400 dialect of SQL.

Read More