Platform-Specific Programming, AS/400, SQL, Database Administration & Management, SQL (Programming Language), Databases - General & Miscellaneous

SQL 400: A Professional Programmer's Guide

Name: SQL 400: A Professional Programmer's Guide
Author: Tim Martyn, Tim Hartley, Richard Johnson
ISBN: 9780070407992

by Tim Martyn, Tim Hartley, Richard Johnson

Write a review

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.

This practical guide to SQL focuses on data retrieval and manipulation using the powerful AS/400 dialect. In a proven tutorial format, the authors cover a wide range of SQL material, including selecting data from a single table, using built-in functions, defining and manipulating data, and accessing multiple tables.

Reviews

There are no reviews yet. Log in to write one.

Editorials

Booknews

A guide to SQL focusing on the AS/400 DB2/400 dialect, for programmers and users working with relational database management systems in the AS/400 midrange environment. The tutorial format takes readers through SQL tasks that deal with the retrieval and manipulation of data in relational databases, and covers built-in functions, accessing multiple tables, and creating indexes and views. The guide outlines other SQL/400 topics such as the view concept, security, transaction processing, and the role of SQL in a client/server system. Annotation c. Book News, Inc., Portland, OR (booknews.com)