Programming Books C Java PHP Python Learn more Browse Programming Books
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 1, 1998


See all formats and editions Hide other formats and editions
Amazon Price New from Used from
Paperback
"Please retry"
$65.99 $8.81


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.
NO_CONTENT_IN_FEATURE

Shop the new tech.book(store)
New! Introducing the tech.book(store), a hub for Software Developers and Architects, Networking Administrators, TPMs, and other technology professionals to find highly-rated and highly-relevant career resources. Shop books on programming and big data, or read this week's blog posts by authors and thought-leaders in the tech industry. > Shop now

Product Details

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

More About the Author

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

Customer Reviews

5.0 out of 5 stars
5 star
4
4 star
0
3 star
0
2 star
0
1 star
0
See all 4 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. If this review is inappropriate, please let us know.
Sorry, we failed to record your vote. Please try again
3 of 3 people found the following review helpful By Victor_Varela@amway.com 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. If this review is inappropriate, please let us know.
Sorry, we failed to record your vote. Please try again
2 of 2 people found the following review helpful By mcravitz@worldnet.att.net 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. If this review is inappropriate, please let us know.
Sorry, we failed to record your vote. Please try again
1 of 1 people found the following review helpful By dschenck@blazenet.net 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. If this review is inappropriate, please let us know.
Sorry, we failed to record your vote. Please try again

What Other Items Do Customers Buy After Viewing This Item?


Frequently Bought Together

Database Design and Programming for DB2/400 + AS/400: System, Utilities, Database, and Programming (2nd Edition)
Buy the selected items together