Conte, senior technical editor for NEWS/400 magazine, provides a thorough introduction to the design and implementation of application databases on IBM's AS/400. The material is organized into four parts: DDS, database design, SQL, and advanced DB2/400 features, and covers everything from coding DDS and entering CL commands to advanced DB2/400 features such as commitment control, the Open Query File command, database constraints, triggers, and distributed data base access. Each chapter includes numerous examples and exercises. Annotation c. by Book News, Inc., Portland, Or.

From the Publisher

The ultimate guide to DB2/400 programming
Paul Conte, a leading DB2/400 authority with extensive application development experience, provides easy-to-follow instruction in the proper way to create efficient, flexible databases on the AS/400. His explanations and advice assure that you'll handle your design and coding challenges with confidence and professional-level techniques.

This book provides complete coverage of both DDS, the traxditional approach to defining DB2/400 files, and of SQL/400, the industry-standard database language that is IBM's strategic language for the future of DB2/400. With this text, you can be sure of handling not only existing application databases, but also developing new SQL/400 databases. These skills will put you in the forefront of AS/400 application developers.

This book also provides an excellent introduction to practical database design techniques. You get a solid introduction to the relational database model, which underlies the whole DB2/400 architecture and the SQL language. On that foundation, the book explains a step-by-step method of modeling an organization's database requirements and developing a design for the necessary database files.

The text is designed for college-level courses and for independent study. Each chapter has numerous examples and exercises. The material is organized into four parts -- DDS, database design, SQL, and advanced DB2/400 features -- so you can focus on particular topics as needed. Appendices provide extensive reference material. You can use the book as your single DB2/400 resource, eliminating the need for many IBM manuals.

You will find "Database Design and Programming for DB2/400" immediately useful, whether you are just beginning to learn DB2/400 or you are an experienced developer. You will turn to this book time and time again for advice on the best way to design and program DB2/400 databases.

Comments from reviewers:

"With this book, you will hold in your hands a new standard for database textbooks." -- Frank Soltis, IBM, Chief Architect of the AS/400 and professor of computer engineering, University of Minnesota.

"This is the definitive DB2/400 text and an essential book for any AS/400 application developer." -- John Fulton, IBM, program manager, Data Technologies, AS/400 Division

"Finally! The integrated reference book that DB2/400 deserves. My AS/400 programmers are using Database Programming and Design for DB2/400 instead a stack of IBM manuals, and they are finding the information they need faster." -- Carson Soule, president, CAS, Inc.

"This book is the bible for creating a good foundation for modern AS/400 applications." -- Roger Pence in the "Microsoft and the AS/400" newsletter

"If you buy only one AS/40 book this year, get 'Database Design and Programming for DB2/400.' This is the ultimate guide to the AS/400's database." -- John Szwaronek, president, Universal Software

"This book is very extensive and is quite informative about the AS/400 database. It is a must for the professional's bookshelf." -- Cascade 38/400 User Group Newsletter, February 1997

"This textbook is masterfully written. The author is well-versed in database management concepts and DB2/400 processing. The student will gain insight and knowledge." -- Ted Tucker, CPT instructor, Metropolitan Community College

"This textbook provides clear, concise, and thorough coverage of AS/400 database concepts and techniques. A 'must read' for programmers as well as database personnel." -- Bernie Cinkoske, CIS instructor, IVY Tech State College

"About this title" may belong to another edition of this title.

Store Description

ThriftBooks is a fully independent seller of used books, having sold more than 160 million used and new books since we started in 2003. Each quality used book is sorted, graded, shelved and shipped by hand by our team of dedicated employees in our seven warehouses across the US. We have the best selection of books, in the right condition and format, at everyday low prices. We also have a dedicated, US-based Customer Service team, ranked in the top three by Newsweek for Best Customer Service in 2018 and 2019, so you can shop with confidence. We support and invest in our employees, appreciate and value our customers, and truly believe in the power of the written word to educate, energize, and engage readers of all ages and interests.

Visit Seller's Storefront

Seller's business information

Thrift Books Global LLC
18300 Cascade Ave S, Seattle, WA, 98188, U.S.A.

Sale & Shipping Terms

Terms of Sale

We guarantee each book that we send you. If you have any problems, please contact
our dedicated customer service department. They will do everything possible to
ensure you are happy with your order.

Right of cancellation

If you are a consumer you can cancel the contract in accordance with the following. Consumer means any natural person who is acting for purposes which are outside his trade, business, craft or profession.

INFORMATION REGARDING THE RIGHT OF CANCELLATION

Statutory Right to cancel

You have the right to cancel this contract within 14 days without giving any reason.

The cancellation period will expire after 14 days from the day on which you acquire, or a third party other than the carrier and indicated by you acquires, physical possession of the the last good or the last lot or piece.

To exercise the right to cancel, you must inform us, Books Squared, Books Squared, 3702 La Reunion Pkwy, 75212, Dallas, Texas, U.S.A., +1 253-275-2251, of your decision to cancel this contract by a clear statement (e.g. a letter sent by post, fax or e-mail). You may use the attached model cancellation form, but it is not obligatory. You can also electronically fill in and submit a clear statement on our website, under "My Purchases" in "My Account". If you use this option, we will communicate to you an acknowledgement of receipt of such a cancellation on a durable medium (e.g. by e-mail) without delay.

To meet the cancellation deadline, it is sufficient for you to send your communication concerning your exercise of the right to cancel before the cancellation period has expired.

Effects of cancellation

If you cancel this contract, we will reimburse to you all payments received from you, including the costs of delivery (except for the supplementary costs arising if you chose a type of delivery other than the least expensive type of standard delivery offered by us).

We may make a deduction from the reimbursement for loss in value of any goods supplied, if the loss is the result of unnecessary handling by you.

We will make the reimbursement without undue delay, and not later than 14 days after the day on which we are informed about your decision to cancel with contract.

We will make the reimbursement using the same means of payment as you used for the initial transaction, unless you have expressly agreed otherwise; in any event, you will not incur any fees as a result of such reimbursement.

We may withhold reimbursement until we have received the goods back or you have supplied evidence of having sent back the goods, whichever is the earliest.

You shall send back the goods or hand them over to us or Books Squared, Books Squared ATTN: Returns, 2337 Centerline Industrial Dr, 63146, St. Louis, Missouri, U.S.A., +1 253-275-2251, without undue delay and in any event not later than 14 days from the day on which you communicate your cancellation from this contract to us. The deadline is met if you send back the goods before the period of 14 days has expired. You will have to bear the direct cost of returning the goods. You are only liable for any diminished value of the goods resulting from the handling other than what is necessary to establish the nature, characteristics and functioning of the goods.

Exceptions to the right of cancellation

The right of cancellation does not apply to:

the delivery of newspapers, journals or magazines with the exception of subscription contracts; and
the supply of digital content (including ebooks) which is not supplied on a tangible medium (e.g. on a CD or DVD) if you accepted when you placed your order that we could start to deliver it, and that you could not cancel it once delivery had started.

Model withdrawal form

(complete and return this form only if you wish to withdraw from the contract)

To: (Books Squared, Books Squared, 3702 La Reunion Pkwy, 75212, Dallas, Texas, U.S.A., +1 253-275-2251)

I/We (*) hereby give notice that I/We (*) withdraw from my/our (*) contract of sale of the following goods (*)/for the provision of the following goods (*)/for the provision of the following service (*),

Ordered on (*)/received on (*)

Name of consumer(s)

Address of consumer(s)

Signature of consumer(s) (only if this form is notified on paper)

Date

* Delete as appropriate.

Shipping Terms

All domestic Standard and Expedited shipments are distributed from our warehouses by OSM, then handed off to the USPS for final delivery.

2-Day Shipping is delivered by FedEx, which does not deliver to PO boxes.

International shipments are tendered to the local postal service in the destination country for final delivery – we do not use courier services for international deliveries.

Shipping rates within U.S.A.

Shipping rates within U.S.A.
Order quantity	4 to 8 business days	4 to 8 business days
First item	� 0.00	� 0.00

Delivery times are set by sellers and vary by carrier and location. Orders passing through Customs may face delays and buyers are responsible for any associated duties or fees. Sellers may contact you regarding additional charges to cover any increased costs to ship your items.