Database Design and Programming for DB2/400

Database Design and Programming for DB2/400
Author: Paul Conte
Publisher: 29th Street Press
Total Pages: 0
Release: 1997
Genre: Database design
ISBN: 9781882419067

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, and data backup and recovery. 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 traditional 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. Database Design and Programming for DB2/400 also provides an excellentintroduction 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're 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.

SQL/400 Developer's Guide

SQL/400 Developer's Guide
Author: Paul Conte
Publisher: System iNetwork
Total Pages: 548
Release: 2000
Genre: Computers
ISBN: 9781882419708

IBM and the rest of the computer industry are putting most of their DBMS development efforts into SQL. This reference provides the SQL/400 skills that a successful applications developer needs and shows how to create comprehensive, complex, and professional SQL/400 databases.

AS/400

AS/400
Author: George Lin
Publisher: Prentice Hall
Total Pages: 648
Release: 1995
Genre: Computers
ISBN:

The Application System/400 (AS/400) is IBM's family of full-range, general purpose computers, which encompass a broad range of related models. This book is a complete guide to the AS/400 system, utilities, database structure, and programming.

External Procedures, Triggers, and User-Defined Functions on IBM DB2 for i

External Procedures, Triggers, and User-Defined Functions on IBM DB2 for i
Author: Hernando Bedoya
Publisher: IBM Redbooks
Total Pages: 436
Release: 2016-04-25
Genre: Computers
ISBN: 0738441597

Procedures, triggers, and user-defined functions (UDFs) are the key database software features for developing robust and distributed applications. IBM Universal DatabaseTM for i (IBM DB2® for i) supported these features for many years, and they were enhanced in V5R1, V5R2, and V5R3 of IBM® OS/400® and V5R4 of IBM i5/OSTM. This IBM Redbooks® publication includes several of the announced features for procedures, triggers, and UDFs in V5R1, V5R2, V5R3, and V5R4. This book includes suggestions, guidelines, and practical examples to help you effectively develop IBM DB2 for i procedures, triggers, and UDFs. The following topics are covered in this book: External stored procedures and triggers Java procedures (both Java Database Connectivity (JDBC) and Structured Query Language for Java (SQLJ)) External triggers External UDFs This publication also offers examples that were developed in several programming languages, including RPG, COBOL, C, Java, and Visual Basic, by using native and SQL data access interfaces. This book is part of the original IBM Redbooks publication, Stored Procedures, Triggers, and User-Defined Functions on DB2 Universal Database for iSeries, SG24-6503-02, that covered external procedures, triggers, and functions, and also SQL procedures, triggers, and functions. All of the information that relates to external routines was left in this publication. All of the information that relates to SQL routines was rewritten and updated. This information is in the new IBM Redbooks publication, SQL Procedures, Triggers, and Functions on IBM DB2 for i, SG24-8326. This book is intended for anyone who wants to develop IBM DB2 for i procedures, triggers, and UDFs. Before you read this book, you need to know about relational database technology and the application development environment on the IBM i server.

Database Design and Implementation

Database Design and Implementation
Author: Edward Sciore
Publisher: Springer Nature
Total Pages: 458
Release: 2020-02-27
Genre: Computers
ISBN: 3030338363

This textbook examines database systems from the viewpoint of a software developer. This perspective makes it possible to investigate why database systems are the way they are. It is of course important to be able to write queries, but it is equally important to know how they are processed. We e.g. don’t want to just use JDBC; we also want to know why the API contains the classes and methods that it does. We need a sense of how hard is it to write a disk cache or logging facility. And what exactly is a database driver, anyway? The first two chapters provide a brief overview of database systems and their use. Chapter 1 discusses the purpose and features of a database system and introduces the Derby and SimpleDB systems. Chapter 2 explains how to write a database application using Java. It presents the basics of JDBC, which is the fundamental API for Java programs that interact with a database. In turn, Chapters 3-11 examine the internals of a typical database engine. Each chapter covers a different database component, starting with the lowest level of abstraction (the disk and file manager) and ending with the highest (the JDBC client interface); further, the respective chapter explains the main issues concerning the component, and considers possible design decisions. As a result, the reader can see exactly what services each component provides and how it interacts with the other components in the system. By the end of this part, s/he will have witnessed the gradual development of a simple but completely functional system. The remaining four chapters then focus on efficient query processing, and focus on the sophisticated techniques and algorithms that can replace the simple design choices described earlier. Topics include indexing, sorting, intelligent buffer usage, and query optimization. This text is intended for upper-level undergraduate or beginning graduate courses in Computer Science. It assumes that the reader is comfortable with basic Java programming; advanced Java concepts (such as RMI and JDBC) are fully explained in the text. The respective chapters are complemented by “end-of-chapter readings” that discuss interesting ideas and research directions that went unmentioned in the text, and provide references to relevant web pages, research articles, reference manuals, and books. Conceptual and programming exercises are also included at the end of each chapter. Students can apply their conceptual knowledge by examining the SimpleDB (a simple but fully functional database system created by the author and provided online) code and modifying it.

Mastering the AS/400

Mastering the AS/400
Author: Jerry Fottral
Publisher: System iNetwork
Total Pages: 580
Release: 2000
Genre: Computers
ISBN: 9781583040706

Annotation A hands-on approach to learning library-object structure, utilities and database management capabilities, application development tools, and OS/400 Control Language (CL), for the AS/400 computer. Twelve lessons, based largely on lab exercises, teach students how to communicate with the system, and use its many features, including CL, Query/400, logical files, DFU, SQL, and SDA. Annotation copyrighted by Book News, Inc., Portland, OR.

Data Warehousing and the AS/400

Data Warehousing and the AS/400
Author: Scott Steinacher
Publisher: 29th Street Press
Total Pages: 370
Release: 1998
Genre: Computers
ISBN:

End users are demanding more sophisticated and more useful analyses of the huge volumes of data stored on a company's database. Data warehousing, one of the hottest developments in IT today, is the answer. This book guides the reader through all the need-to-know decision factors for building a data warehouse.

DDS Programming for Display and Printer Files

DDS Programming for Display and Printer Files
Author: James Coolbaugh
Publisher:
Total Pages: 466
Release: 1999
Genre: Computers
ISBN: 9781583040379

New AS/400 programmers will find in this text a systematic approach to data description specifications concepts and the foundation needed to take on complex tasks. Experienced programmers will find it a handy reference to DDS functions they are already using and also an efficient guide to very advanced applications.

Beginning Database Design

Beginning Database Design
Author: Gavin Powell
Publisher: John Wiley & Sons
Total Pages: 496
Release: 2006
Genre: Computers
ISBN: 0764574906

From the #1 source for computing information, trusted by more than six million readers worldwide.