by Brian W. Kelly Book Description Finally, there is a Pocket Developer's Guide for native AS/400 and iSeries database development. Yes, it is in big pocket guide form and it is tutorial in nature. You'll be pleased with all the valuable examples. You won't want to put down this comprehensive guide to DB2/400 when you get your hands on it. As you may know, there typically is no DB Administrator position in AS/400 shops. The database job is up to you - the AS/400 and iSeries Application Developer. Though rich in content, IBM's reference manuals are not built to teach you. They are for reference. This pocket guide is different. It is your teaching/learning vehicle to the native database. It is your new tool to help you solve programming problems more efficiently with database coding - rather than have to work harder building program code. This guide has an example for these database functions: • Creating Physical files with a field reference file • Performing simple and complex DDS selects and omits • Unions • Multi-format non-join logical merges • Simple joins • Multiple file joins • Much, much more! Contents: Preface Chapter 1. What is a Database? Chapter 2. AS/400, iSeries, and Relational Database Chapter 3. AS/400 and iSeries Database Concepts Chapter 4. Creating Physical and Logical Files Chapter 5. Data Management Attributes Chapter 6. The Database File Object & DB Theory Chapter 7. DDS Levels a.k.a the DDS Hierarchy Chapter 8. The DDS Specification for Database Files Chapter 9. Example DDS - Physical Files Coding Chapter 10. Coding for Multiple member Physical Files Chapter 11. Copy Utility for Populating Physical Files Chapter 12. Intro to Logical File Coding - DDS Levels Chapter 13. LF Coding Examples - Non Join Format Ops Chapter 14. LF Coding Examples - Non Join Field Ops Chapter 15. LF Coding Examples - Key & S/O Level Ops Chapter 16. Logical File Coding Examples - Join Keywords Chapter 17. Logical File Coding Examples - Join Operations Chapter 18. Dynamic Record Selectxion - DYNSLT Chapter 19. Date and Time Formats Chapter 20. Summary and Conclusions Appendix Glossary About the Author Brian Kelly retired as a 30-year IBM Midrange SE in 1999, having cut his eye teeth in 1969 on the System/3 and later with CCP. While with IBM, he was also a Certified Instructor and a Mid-Atlantic Area Designated Specialist. Kelly takes pride in having announced the AS/400 at Marywood University in June, 1988. When IBM began to move its sales and support to Business Partners, he formed Kelly Consulting in 1992 as an IT education and consulting firm. Kelly developed numerous AS/400 professional courses over the years that range from soup to nuts. He has written twenty-one books and numerous magazine articles about current IT topics, including articles for The Four Hundred, Midrange Computing, Showcase, News/400, AS/400 Systems Management, AS/400 Internet Expert, and others. Kelly has also developed and taught a number of college courses and is currently an adjunct member of the graduate faculty at Marywood University in Scranton, Pennsylvania, where he also serves as iSeries technical advisor to the IT faculty. |
Guild Companies · 50 Park Terrace East, Suite 8F, New York, NY 10034 · Telephone: (212) 942-5818 · Email: store@itjungle.com |