Flylib.com
Intelligent Enterprises of the 21st Century
Intelligent Enterprises of the 21st Century
ISBN: N/A
EAN: 2147483647
Year: 2003
Pages: 205
Authors:
Jatinder N. D. Gupta
,
S. K. Sharma
BUY ON AMAZON
DB2 SQL PL, Second Edition: Deployment and Advanced Configuration Essential Guide for DB2 UDB on Linux., UNIX, Windows , i5OS, zOS
Table of Contents
Copyright
IBM Press
On Demand Computing Books
DB2 Books
More Books from IBM Press
Contributors
Acknowledgments
About the Authors
Foreword
Chapter 1. Introduction
Installing DB2
History of Stored Procedures
A Brief Introduction to Stored Procedures, Triggers, and Functions
What s New in the Second Edition
Book Conventions
Chapter 2. Basic SQL Procedure Structure
The CREATE PROCEDURE Statement
The SQL Procedure Body Structure
Bringing It All Together Example
DB2 UDB for iSeries Considerations
DB2 UDB for zSeries Considerations
Summary
Chapter 3. Overview of SQL PL Language Elements
DB2 Data Types
Large Objects
Choosing Proper Data Types
Working with User-Defined Distinct Types
Data Manipulation
Working with Generated Columns
Working with Identity Columns and Sequence Objects
Platform Portability Considerations
Summary
Chapter 4. Using Flow of Control Statements
Compound Statements
Conditional Statements
Looping Statements
Transfer of Control Statements
Summary
Chapter 5. Understanding and Using Cursors and Result Sets
Using Cursors in SQL Procedures
Positioned Delete
Positioned Update
Selecting Data from UPDATE, INSERT, or DELETE Statements
Cursor Behavior with COMMITROLLBACK
Using Cursors to Return Result Sets
Returning Multiple Result Sets
Cursors and Locking
DB2 UDB for iSeries Considerations
Summary
Chapter 6. Condition Handling
Basic Error Checking: SQLCODE and SQLSTATE
Condition Handlers
Custom Errors and Error Messages
Processing Results from Called Procedures
Bringing It All Together
DB2 UDB for iSeries Considerations
DB2 UDB for zSeries Considerations
Summary
Chapter 7. Working with Dynamic SQL
PREPARE and EXECUTE: The Two Phases of Any SQL Statement
Dynamic SQL Versus Static SQL
Restrictions and Considerations
Using Dynamic SQL with EXECUTE IMMEDIATE
Escaping Single Quotes ( )
Reusing Dynamic SQL Statements with PREPARE and EXECUTE
Using Dynamic SQL in Cursors
Dynamic CALL Statements
Authorization Consideration
Summary
Chapter 8. Nested SQL Procedures
Basic Nested SQL Procedures
Passing Parameters Between Nested SQL Procedures
Returning Values from Nested SQL Procedures
Returning Result Sets from Nested SQL Procedures
Receiving Results from a Procedure in a Trigger
Levels of Nesting
Security
Summary
Chapter 9. User-Defined Functions and Triggers
The CREATE FUNCTION Statement
User-Defined Functions by Examples
The CREATE TRIGGER Statement
Triggers by Examples
Considerations for Invoking SQL Procedures from UDFs and Triggers
DB2 for iSeries Considerations
DB2 for zSeries Considerations
Summary
Chapter 10. Leveraging DB2 Application Development Features
Leveraging Advanced SQL
Declared Global Temporary Tables
Working with Save Points
Sequence Objects
Summary
Chapter 11. Deploying SQL Procedures, Functions, and Triggers
Deploying on Linux, UNIX, and Windows
Deployment Considerations for DB2 for zSeries
Common Deployment Considerations for LUW and zSeries
Deploying in DB2 UDB for iSeries
Summary
Chapter 12. Performance Tuning
Performance Considerations for LUW
DB2 for iSeries Considerations
DB2 for zSeries Considerations
Summary
Chapter 13. Best Practices
Table and Index Best Practices
Best Practices for Easier Code Maintenance
Best Practices for Performance
Working with Result Sets
Precompile Options on iSeries
Summary
Appendix A. Getting Started with DB2
Getting Started with DB2 UDB for LUW
Getting Started with DB2 UDB for iSeries
Getting Started with DB2 UDB for zSeries
Summary
Appendix B. Inline SQL PL for DB2 UDB for Linux, UNIX, and Windows
Dynamic Compound Statement
Stand-Alone Code
Choosing Between Dynamic Compound Statements and SQL Procedures
Summary
Appendix C. Building from the Command Line
Configuring the Build Environment
Building SQL Procedures
Building SQL Procedures in DB2 UDB for iSeries
Building SQL Procedures in DB2 for zSeries
Summary
Appendix D. Using the DB2 Development Center
Installing the DB2 Development Center
DB2 for Windows
DB2 for Linux and UNIX
Using the Development Center for the First Time
Development Center Views
Customizing the Development Center
Running Procedures
Stored Procedure Run Settings
Debugging Stored Procedures
Debugging Nested Stored Procedures
Working with Projects
Importing Stored Procedures
DB2 for iSeries Considerations
DB2 for zSeries Considerations
Environment Settings
Developing SQL Stored Procedures from the Development Center
The Project and Server Views
Debugging DB2 for zSeries SQL Stored Procedures
Summary
Appendix E. Security Considerations in SQL Procedures
Privileges
Using Stored Procedures in a Production Environment
DB2 for zSeries Considerations
The DEFINE Behavior
The INVOKE Behavior
Common Attribute Values for the DEFINE and INVOKE Behaviors
Simplifying Authorization
Summary
Appendix F. DDL
Creating the SAMPLE Database on LUW
Creating the SAMPLE Database on iSeries
Creating the SAMPLE Database on zSeries
SAMPLE Database DDL: Script 1 sampleDDL_1.db2
DDL for Additional Database Objects: Script 2 sampleDDL_2.db2
Appendix G. Additional Resources
IBM Redbooks
Certification
Education
Books
Additional Websites
Email Services and Periodicals
User Groups and Conferences
Appendix H. Sample Application Code
Receiving Result Sets in Java
Receiving Result Sets in a C or C Application
Receiving Multiple Result Sets in Java
Receiving Multiple Result Sets in a C or C Application
CD-ROM Warranty
Index
SYMBOL
A
B
C
D
E
F
G
H
I
J
K
L
M
N
O
P
Q
R
S
T
U
V
W
Z
Intelligent Enterprises of the 21st Century
ISBN: N/A
EAN: 2147483647
Year: 2003
Pages: 205
Authors:
Jatinder N. D. Gupta
,
S. K. Sharma
BUY ON AMAZON
Inside Network Security Assessment: Guarding Your IT Infrastructure
Security and the Employee (Social Engineering)
What Do Attackers Do?
Reducing the Risk of an Attack
A Brief History of Security Tools
Conclusions
Documenting Software Architectures: Views and Beyond
Summary Checklist
Chunking Information: View Packets, Refinement, and Descriptive Completeness
Documenting a View
Discussion Questions
Directory
Developing Tablet PC Applications (Charles River Media Programming)
The Tablet PC
Object-Oriented Programming with VB .NET
Your First Program
Console Application Input/Output
Custom Grammars for Speech Recognition
Visual C# 2005 How to Program (2nd Edition)
Self-Review Exercises
Exercises
Char Methods
Font Control
G.8. meta Elements
C & Data Structures (Charles River Media Computer Engineering)
Data Types
Control Structures
Address and Pointers
Preprocessing
Stacks and Queues
Mastering Delphi 7
Visual Controls
Building the User Interface
Writing Delphi Components
From COM to COM+
Appendix C Free Companion Books on Delphi
flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net
Privacy policy
This website uses cookies. Click
here
to find out more.
Accept cookies