SQL 400 A Professional Programmer's Guide

Name: SQL 400 A Professional Programmer's Guide
Availability: OutOfStock
ISBN: 9780070407992

ISBN-10: 0070407991

ISBN-13: 9780070407992

Edition: N/A

Authors: Tim Martyn, Tim Hartley, Richard Johnson

List price: $45.00

30 day, 100% satisfaction guarantee!

Out of stock

We're sorry. This item is currently unavailable.

what's this?

Rush Rewards U
Members Receive:

You have reached 400 XP and carrot coins. That is the daily max!

Description:

This practical guide to SQL focuses on data retrieval and manipulation using the powerful AS/400 dialect.

Book details

List price: $45.00
Publisher: McGraw-Hill Companies, The
Binding: Hardcover
Pages: 499
Size: 7.50" wide x 9.50" long x 1.50" tall
Weight: 2.332
Language: English



Preface


Acknowledgments


Introduction



SELECTing Data from a Single Table



The SELECT Statement



An Introduction to Query Manager



Sorting the "Result" Table



Boolean Connectors: AND-OR-NOT



Pattern Matching



Arithmetic Expressions



SQL/400 Built-in Functions



Column Functions



Scalar Functions



Processing Date and Time Information



Query Manager



Report Formatting



More About Query Manager



Data Definition and Manipulation



Data Definition



Data Manipulation



Processing Null Values



Accessing Multiple Tables



Join Operation



Subqueries



UNION Operation



Correlated Subqueries



More about SQL/400



The View Concept



Database Security



Exploring SQL/400 Collections



Commitment Control



DB2/400: SQL/400 Joins the DB2 Family



Database Integrity in DB2/400



DB2/400: A Client-Server DBMS



Overview of DB2/400 API


Appendix A Entering and Exiting Query Manager


Appendix B Educational Database


Appendix C Using the Educational Database


Appendix D Answers to Exercises


Index