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
Product Details:
Audience:
Database Administrators and Programmers
Level:
Novice to Intermediate
Subject:
Database Administration
Length:
350 pages
Format:
Paperback, Perfectbound
Publisher:
Let's Go Publish
The iSeries Pocket Database Guide Author: Brian Kelly
Get The Database Book That's 20 Years Overdue
