SQL for eServer i5 and iSeries : SQL

0 item(s) in My Cart

Home
Top 10 List
SQL for eServer i5 and iSeries

Item No.: 5063

- - generic_text_1: Create a Cutting-Edge Database

- - Publisher: MC Press
  - ISBN Number: 1583470484
  - ISBN-13/EAN: 9781583470480

- - generic_text_4:
    Look Inside the Book:

SQL for eServer i5 and iSeries

- - Author: Kevin Forsythe
  - Binding: Paperback
  - generic_text_3: 568
  - Publication date: 2004

This item is on sale

Sale: $51.96
Our price:: $64.95
You save: $12.99 (20%)
Save An Extra 15% Off Our Lowest Hard Copy Price, visit the MC Press eBookstore.

Buy Box

Quantity:
Availability:

In Stock
Availability:

Usually ships in 24 hours

Buy Box

Quantity:
Availability:

In Stock
Availability:

Usually ships in 24 hours

Not yet rated. Be the first to write a review

Product Details

In this book, you will learn about Structured Query Language (SQL), but with an IBM eServer i5/iSeries twist. The future seems clear on this point: SQL is the direction of the future for IBM's Universal Database. While it is true that the majority of existing databases on the i5 and iSeries were created with DDS, it is still undeniable that DDS will slowly fade from use, much like the RPG program cycle.

With a practical "how-to" style, SQL for eServer i5 and iSeries first introduces you to the basics essential for any developer to build a solid foundation. Then the book examines--in detail--the many ways in which SQL functions on the iSeries. All possible environments are explored: the traditional 5250 green-screen applications, the SQL scripting tool within iSeries Navigator, and the methods of accessing iSeries databases from within Visual Basic.

Learn through real-life examples of using SQL to interact with DB2 databases. Discover the ins and outs of sub-selects, joins, unions, and views, as well as tips and techniques for interacting with legacy applications and so much more. Though the book is intended for programmers already familiar with SQL, beginners will appreciate the book's handy tutorial Appendix to get started with SQL basics.

After reading this book, you will see that the i5/iSeries platform is far more than the green-screen application server it is often perceived as and that it is indeed one of the finest systems available for use as a business server today. Make your database access cutting-edge with SQL for eServer i5 and iSeries.

In this book you will learn to:

Published by: MC Press
Merchant SKU: 5063
Incorporate SQL into existing iSeries business and client-side applications
Embed SQL within RPG programs--merging the flexibility of SQL with the power of RPG
Implement referential constraints-primary and unique key indexes-and check constraints
Journal physical files and find out why this task is so important
Extend your database with user-defined functions and procedures
Use new GUI development tools for running-debugging-and tuning SQL statements

Author Bio
- - generic_text_2: Kevin Forsythe has more than 19 years of experience on the iSeries and other platforms as programmer, analyst, consultant, and instructor. He blends a wide range of experiences with a passion for teaching and is the author of numerous articles. He is a frequent and award-winning speaker at COMMON conferences and other user conferences.