SQL/400: A Professional Programmer's Guide

SQL/400: A Professional Programmer's Guide

Hardcover

$37.67 $45.00 Save 16% Current price is $37.67, Original price is $45. You Save 16%.

Overview

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. The book is packed with information on SQL/400,including database security and transaction processing,and it explores the AS/400 catalog.

Product Details

ISBN-13: 9780070407992
Publisher: McGraw-Hill Companies, The
Publication date: 03/01/1995
Series: J. Ranade IBM Series
Pages: 499
Product dimensions: 7.61(w) x 9.57(h) x 1.26(d)

Table of Contents

Part I: Selecting Data From a Single Table: The Select Statement.

Sorting the "Result" Table.

Boolean Connectors: And-or-Not.

Pattern Matching.

Arithmetic Expressions.

Part II: Built-In Functions: Column Functions.

Scalar Functions.

Part III: Data Definition and Manipulation: Data Definition.

Data Manipulation.

Processing Null Values.

Part IV: Accessing Multiple Tables: The Join Operation.

UNION.

Subqueries.

Correlated Subqueries.

Part V: More About SQL/400: The View Concept.

Database Security.

Transaction Processing.

Exploring the AS/400 Catalog.

Customer Reviews

Most Helpful Customer Reviews

See All Customer Reviews