SQL/400
A Professional Programmer's Guide
Published on 1. January 1995
Book
Hardback
528 pages
978-0-07-040799-2 (ISBN)
Description
This practical guide to SQL focuses on data retrieval and manipulation using the powerful AS/400 dialect. In a 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 full of information on SQL/400, including database security and transaction processing, and it explores AS/400 catalogue.
More details
Series
Language
English
Place of publication
New York
United States
Publishing group
McGraw-Hill Education - Europe
Target group
Professional and scholarly
Illustrations
10 illustrations
Dimensions
Height: 235 mm
Width: 188 mm
ISBN-13
978-0-07-040799-2 (9780070407992)
Copyright in bibliographic data is held by Nielsen Book Services Limited or its licensors: all rights reserved.
Schweitzer Classification
Content
Part 1 Selecting data from a single table: the select statement; sorting the "result" table; Boolean connectors - and-or-not; pattern matching; arithmetic expressions. Part 2 Built-in functions: column functions; scalar functions. Part 3 Data definition and manipulation: data definition; data manipulation; processing null values. Part 4 Accessing multiple tables: the join operation; UNION; subqueries; correlated subqueries. Part 5 More about SQL/400: the view concept; database security; transaction processing; exploring the AS/400 catalogue; appendices.