Michael L. Gonzales, El Paso, TX

Published July, 1995 by Prentice Hall PTR (ECS Professional)

Copyright 1996, 176 pp.
Paper Bound with Disk
ISBN 0-13-206723-4

Sign up for future
mailings on this subject.

See other books about:
    Other Languages--Programming-Computer Science

This Book helps the reader understand Informix stored procedures, which can be used to dramatically improve the performance of SQL code, tighten security, reduce maintenance of permissions, and maximize data integrity.




presents an understanding of the structure, program logic flow and control of stored procedures, as used in the Informix Stored Procedure Language (SPL) - Informix' version of middleware.
extensive examples show how to design and apply stored procedures of the right size and scope.
shows how stored procedures can be used to optimize code while improving security and data integrity.
a comprehensive SPL syntax reference is included, as are more than 20 stored procedures that can be used or adapted by the reader.

Preface.

What You Need to Know before Starting. The Scope of This Handbook. Handbook Format. Chapter. Introduction. The Promise of Stored Procedures. The Balance between Database Independence and Data Integrity.

Chapter 2.

Defining Stored Procedures. What Is a Stored Procedure? What Can You Do with SPs? How Are SPL Objects Created? Where Are SPL Objects Stored? How Are SPs Executed?

Chapter 3.

Dissecting Stored Procedures. Paired PROCEDURE Statements. Returning Values. Stored Procedure Arguments. Defining Program Variables. Statement Blocks.

Chapter 4.

Controlling Stored Procedures. Invoking Stored Procedures. Flow Control. Error Trapping. Database Paths and SPL Objects.

Chapter 5.

Speeding Up with SPs. The Client/Server. An MIS Ritual. A Typical 4GL Data Manipulation Strategy. The Optimum Freight Object. The Efficiency of Encapsulation.

Chapter 6.

Fortifying Security. The Sphere of Security. Security GRANTs. Security and Stored Procedures.

Chapter 7.

Protecting Data Integrity. Transaction Logging. The Shotgun Approach to Transactions. The Rifle Approach to Transactions. Adherence to Business Rules.

Chapter 8.

Determining Right Size, Right Scope. Comparison Model. The Post-it Test. An Object Survey.

Chapter 9.

Applying Stored Procedures. "Loosely Coupled" Data Replication. Chronological Audit Archiving.

Appendix A. SPL Reference Manual Pages.
Appendix B. Stored Procedure Errors.
Appendix C. Orders-R-Us Database, Orders-R-Us Company Structure.
Appendix D. SPL Version Differences. Additional Features of Informix 6.x SPs. Additional Features of Informix 7.x SPs
Appendix E. SP Object Pack Review.
Function: Loosely Coupled Data Replication.
Function: Chronological Audit Archiving.
Function: Encryptor/Decryptor.
Function: Root Calculator.
Function: Stored Procedure Monitor.
Function: Stored Procedure Query.
Function: Stored Procedure Schema.
Key Word Glossary.
Index.

---

© Prentice-Hall, Inc. A Simon & Schuster Company Comments To webmaster@prenhall.com