SQL/400: A Professional Programmer's Guide

Be the first to 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 ...
See more details below
Available through our Marketplace sellers.
See All Options
Other sellers (Hardcover)
  • All (7) from $11.36   
  • Used (7) from $11.36   
Close
Sort by
Page 1 of 1
Showing All
Note: Marketplace items are not eligible for any BN.com coupons and promotions
$11.36
AtlantaBookCompany
Seller since Thu Jan 01 01:01:01 EST 2009

Feedback rating:

(10977)

Condition:

New — never opened or used in original packaging.

Like New — packaging may have been opened. A "Like New" item is suitable to give as a gift.

Very Good — may have minor signs of wear on packaging but item works perfectly and has no damage.

Good — item is in good condition but packaging may have signs of shelf wear/aging or torn packaging. All specific defects should be noted in the Comments section associated with each item.

Acceptable — item is in working order but may show signs of wear such as scratches or torn packaging. All specific defects should be noted in the Comments section associated with each item.

Used — An item that has been opened and may show signs of wear. All specific defects should be noted in the Comments section associated with each item.

Refurbished — A used item that has been renewed or updated and verified to be in proper working condition. Not necessarily completed by the original manufacturer.

Very Good
Light wear to edges and pages. Cover and spine show no easily noticeable damage. A tradition of southern quality and service. All books guaranteed at the Atlanta Book Company. Our ... mailers are 100% recyclable. Read more Show Less

Ships from: Atlanta, GA

Usually ships in 1-2 business days

  • •Canadian
  • •International
  • •Standard, 48 States
  • •Standard (AK, HI)
  • •Express, 48 States
  • •Express (AK, HI)
$11.36
Virginia Social Ventures VA
Seller since Sat Jan 01 01:01:01 EST 2005

Feedback rating:

(1100)

Condition: Good
1995 Hardcover Books rated "Good" may have some notes, underlining, or highlighting. These books also may contain the previous owner's name, stamp, sticker, or gift inscription, ... or may be library discards. Read more Show Less

Ships from: Norfolk, VA

Usually ships in 1-2 business days

  • •Canadian
  • •International
  • •Standard, 48 States
  • •Standard (AK, HI)
  • •Express, 48 States
  • •Express (AK, HI)
$11.84
Better World Books
Seller since Sun Jan 01 01:01:01 EST 2006

Feedback rating:

(60347)

Condition: Good
Former Library book. Shows some signs of wear, and may have some markings on the inside. 100% Money Back Guarantee. Shipped to over one million happy customers. Your purchase ... benefits world literacy! Read more Show Less

Ships from: Mishawaka, IN

Usually ships in 1-2 business days

  • •Canadian
  • •International
  • •Standard, 48 States
  • •Standard (AK, HI)
  • •Express, 48 States
  • •Express (AK, HI)
$19.99
HPB - Redmond
Seller since Sun Sep 28 04:00:28 EDT 2014

Feedback rating:

(1)

Condition: Good
1995 Hardcover Good Connecting readers with great books since 1972. Used books may not include companion materials, some shelf wear, may contain highlighting/notes, and may not ... include cd-rom or access codes. Customer service is our top priority! Read more Show Less

Ships from: Redmond, WA

Usually ships in 1-2 business days

  • •Standard, 48 States
  • •Standard (AK, HI)
  • •Express, 48 States
  • •Express (AK, HI)
$36.99
SUPER BOOKS
Seller since Tue Oct 07 09:42:27 EDT 2014

Feedback rating:

(55)

Condition: Good
Buy with Confidence. Excellent Customer Support. We ship from multiple US locations. No CD, DVD or Access Code Included.

Ships from: Fort Mill, SC

Usually ships in 1-2 business days

  • •Standard, 48 States
$51.10
Books Revisited
Seller since Tue Oct 07 09:35:53 EDT 2014

Feedback rating:

(294)

Condition: Very Good
Very good.

Ships from: Chatham, NJ

Usually ships in 1-2 business days

  • •Canadian
  • •International
  • •Standard, 48 States
  • •Standard (AK, HI)
  • •Express, 48 States
  • •Express (AK, HI)
$51.14
Books Revisited
Seller since Tue Oct 07 09:35:53 EDT 2014

Feedback rating:

(294)

Condition: Good
Possible retired library copy, some have markings or writing. May or may not include accessories such as CD or access codes.

Ships from: Chatham, NJ

Usually ships in 1-2 business days

  • •Canadian
  • •International
  • •Standard, 48 States
  • •Standard (AK, HI)
  • •Express, 48 States
  • •Express (AK, HI)
Page 1 of 1
Showing All
Close
Sort by
Sending request ...

More About This Book

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.

Read More Show Less

Editorial Reviews

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)
Read More Show Less

Product Details

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

Table of Contents

Preface
Acknowledgments
Introduction 1
Pt. 1 SELECTing Data from a Single Table 11
Ch. 1 The SELECT Statement 15
Ch. 2 An Introduction to Query Manager 39
Ch. 3 Sorting the "Result" Table 53
Ch. 4 Boolean Connectors: AND-OR-NOT 65
Ch. 5 Pattern Matching 97
Ch. 6 Arithmetic Expressions 111
Pt. 2 SQL/400 Built-in Functions 127
Ch. 7 Column Functions 129
Ch. 8 Scalar Functions 153
Ch. 9 Processing Date and Time Information 165
Pt. 3 Query Manager 179
Ch. 10 Report Formatting 181
Ch. 11 More About Query Manager 197
Pt. 4 Data Definition and Manipulation 203
Ch. 12 Data Definition 205
Ch. 13 Data Manipulation 229
Ch. 14 Processing Null Values 245
Pt. 5 Accessing Multiple Tables 267
Ch. 15 Join Operation 269
Ch. 16 Subqueries 307
Ch. 17 UNION Operation 341
Ch. 18 Correlated Subqueries 355
Pt. 6 More about SQL/400 383
Ch. 19 The View Concept 385
Ch. 20 Database Security 407
Ch. 21 Exploring SQL/400 Collections 415
Ch. 22 Commitment Control 425
Pt. 7 DB2/400: SQL/400 Joins the DB2 Family 433
Ch. 23 Database Integrity in DB2/400 435
Ch. 24 DB2/400: A Client-Server DBMS 441
Ch. 25 Overview of DB2/400 API 457
Appendix A Entering and Exiting Query Manager 463
Appendix B Educational Database 467
Appendix C Using the Educational Database 471
Appendix D Answers to Exercises 479
Index 493
Read More Show Less

Customer Reviews

Be the first to write a review
( 0 )
Rating Distribution

5 Star

(0)

4 Star

(0)

3 Star

(0)

2 Star

(0)

1 Star

(0)
    If you find inappropriate content, please report it to Barnes & Noble
    Why is this product inappropriate?
    Comments (optional)