ACDelco Radiators & Heating Components 100 Sci-Fi & Fantasy Shop Men's Watches Cloud Drive Photos nav_sap_plcc_6M_fly_beacon Janet Jackson belkin Fire TV Stick Beauty Videos Introducing Handmade Create an Amazon Wedding Registry Amazon Gift Card Offer wdftv wdftv wdftv  Amazon Echo Starting at $49.99 Kindle Voyage Nintendo Digital Games Shop Now Learn more

Enter your mobile number or email address below and we'll send you a link to download the free Kindle App. Then you can start reading Kindle books on your smartphone, tablet, or computer - no Kindle device required.

  • Apple
  • Android
  • Windows Phone
  • Android

To get the free app, enter your email address or mobile phone number.

Buy Used
+ $3.99 shipping
Used: Good | Details
Condition: Used: Good
Comment: 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!
Have one to sell? Sell on Amazon
Flip to back Flip to front
Listen Playing... Paused   You're listening to a sample of the Audible audio edition.
Learn more
See this image

Database Design and Programming for DB2/400 Paperback – January, 1998

5 customer reviews

See all formats and editions Hide other formats and editions
Amazon Price
New from Used from
"Please retry"
$129.95 $3.51

Speaking Well
Speaking Well
The thought of speaking in public strikes fear in the hearts of many. Adam Hamilton offers nineteen powerful tips and tactics that lead to excellent speaking in any setting. See more

Editorial Reviews

From the Publisher

Database Design and Programming for DB2/400 is a comprehensive introduction to the design and implementation of application databases on IBM's AS/400. This clear and authoritative text teaches you the following essential skills:

Coding Data Description Specifications (DDS) for physical and logical files

Entering CL commands to create DB2/400 files from DDS

Using field reference files

Accessing database files from RPG IV, RPG/400, COBOL/400, and other AS/400 high-level languages

The Relational Database Model as a foundation for DB2/400 and database design

Practical database design and data modeling

Using SQL/400 to define and access database files

Advanced DB2/400 features (including commitment control, the Open Query File command, database constraints, triggers, distributed database access, and others)

Database security

Data backup and recovery

About the Author

Paul Conte is president of Picante Software, Inc., a software development company in Eugene, Oregon. He’s also a senior technical editor for NEWS/400 magazine. Paul is a widely published expert on database systems, database design, software engineering, and programming languages. He’s considered a leading authority on DB2/400, and his articles have appeared in NEWS/400, Database Programming & Design, Computer Language, and numerous other publications. Paul also consults and speaks frequently on database issues. Paul has developed applications on a variety of platforms and relational DBMS, including the AS/400, S/38, S/370, DEC, and PCs with DB2, Oracle, Ingres, and Access. He is the principle architect and developer of several commercial software products, including Flex/EDIT, a widely used Windows-based AS/400 programmer’s workbench. Paul has a B.A. in psychology from Georgia State University and an M.S. in computer science from the University of Oregon. He served on the University of Oregon faculty for eight years and ran his own consulting firm before starting Picante Software.


Best Books of the Month
Best Books of the Month
Want to know our Editors' picks for the best books of the month? Browse Best Books of the Month, featuring our favorite new books in more than a dozen categories.

Product Details

  • Paperback: 600 pages
  • Publisher: 29th Street Press (January 1998)
  • Language: English
  • ISBN-10: 1882419065
  • ISBN-13: 978-1882419067
  • Product Dimensions: 10.1 x 8.5 x 2 inches
  • Shipping Weight: 4.3 pounds
  • Average Customer Review: 5.0 out of 5 stars  See all reviews (5 customer reviews)
  • Amazon Best Sellers Rank: #786,931 in Books (See Top 100 in Books)

More About the Author

Discover books, learn about writers, read author blogs, and more.

Customer Reviews

5 star
4 star
3 star
2 star
1 star
See all 5 customer reviews
Share your thoughts with other customers

Most Helpful Customer Reviews

5 of 5 people found the following review helpful By Rolf André on February 7, 1999
Format: Paperback
I wish I had this book as soon as it was published. After programming on the S/38 and the AS/400 (in RPG) for over 14 years now (with some interruptions), I consider this one the best AS/400-related computing book I have purchased - ever! And compared to other computer books, well, if only that kind of quality would be available on other topics as well more frequently, either DBMS's or programming languages. The book saved one of my clients hours of work: with no previous SQL knowledge but having this book they were able to do some work with SQL that otherwise would have required them to write a program. Another client (and myself for my own system) took advantage of the chapters on Referential Integrity. If you're serious about accessing your data on your DB2/400 database, you owe it to yourself to buy this book !
Comment Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback.
Sorry, we failed to record your vote. Please try again
Report abuse
3 of 3 people found the following review helpful By on November 13, 1998
Format: Paperback
It has become my daily Bible in my job as an AS/400 DBA. Even after reading the whole book last winter, I still seem to read a passage from it everytime I need inspiration on doing something new or different (or that I can't remember how it is done) with DB2/400.
I am looking to modernize our AS/400 database development with the latest modeling tools and functions without disrupting the traditional DDS-centric RPG development efforts of my programmer customers. I serve customers in dozens of countries with varying levels of SQL/400 knowledge, but being an ex-mainframe DBA, I appreciate the effort IBM has placed into DB2/400 (or "DB2 for AS/400") into giving it mainframe-DB2-like capabilities. I am hoping Paul Conte will come up with a new edition of this book for OS/400 V4.3 because I would love to see these issues addressed in the same manner that DB2/400 V3.6 is presented in this book. Maybe even a chapter devoted to interoperability issues between DDS and SQL/400 and why/how to make the migration would be splendid.
Comment Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback.
Sorry, we failed to record your vote. Please try again
Report abuse
2 of 2 people found the following review helpful By on September 5, 1997
Format: Paperback
This is the best work on the subject available today. Paul obviously put his heart, soul and considerable talent into this book. It's hard to believe that a book so filled with useful information is available at the rather low price of $75.

----small errata----

There's an error on page 410, 2nd paragraph. The sentence which starts out "Although the SQL precompiler requires Declare Cursor statements to be coded in the procedureal part of a program..." is not true for Cobol. Cobol allows you to put Declare Cursor in the Working-Storage Section as well.
Comment Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback.
Sorry, we failed to record your vote. Please try again
Report abuse
1 of 1 people found the following review helpful By on December 18, 1997
Format: Paperback
Having programmed the AS/400 since its inception, I thought I knew everything about the DB2/400 database. But Conte's insightful volume reveals new possibilities and capabilities.
Filled with a perfect mix of theory and hands-on examples, this book allows a reader of any level of experience to benefit from the author's many years of expertise. Conte is a stickler for professionalism and attention to detail, and "Database Design And Programming For DB2/400" not only typifies his love of excellence, but encourages the reader to raise his or her own personal expectations.
If you're a manager, buy every programmer a copy and make it mandatory reading. If you're a programmer who wants to be the best, you must have this book; my copy rests at arm's length on my desk. If you're an educator, this would make an ideal textbook.
Comment Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback.
Sorry, we failed to record your vote. Please try again
Report abuse
Format: Paperback Verified Purchase
Excellent book on the relational database DB2. The chapters on SQL were also very good. His follow-up book SQL/400 is also a great text book, covers embedded SQL and database design.
Comment Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback.
Sorry, we failed to record your vote. Please try again
Report abuse

Want to discover more products? Check out these pages to see more: software engineering, data modeling