Stimmen - 0, Durchschnittliche Bewertung: 0
(
)
)
|
Dieses Gerät hat auch andere Anweisungen:
Anleitung Zusammenfassung
Document Outline
- 1 Introduction
- 2 Using ALLBASE/SQL
- Creating DBEnvironments
- Starting and Terminating a DBE Session
- Creating Physical Storage
- Defining How Data is Stored and Retrieved
- Understanding Data Access Paths
- Controlling Database Access
- Manipulating Data
- Managing Transactions
- Auditing DBEnvironments
- Using Wrapper DBEnvironments
- Using SQLAudit
- Application Programming
- Using Multiple Connections and Transactions with Timeouts
- Administering a Database
- Understanding the System Catalog
- 3 SQL Queries
- 4 Constraints, Procedures, and Rules
- Using Integrity Constraints
- Using Procedures
- Understanding Procedures
- Creating Procedures
- Executing Procedures
- Procedures and Transaction Management
- Using SQL Statements in Procedures
- Queries inside Procedures
- Using a Procedure Cursor in ISQL
- Error Handling in Procedures Not Invoked by Rules
- Using RAISE ERROR in Procedures
- Recommended Coding Practices for Procedures
- Using Rules
- Understanding Rules
- Creating Rules
- Techniques for Using Procedures with Rules
- Error Handling in Procedures Invoked by Rules
- Using RAISE ERROR in Procedures Invoked by Rules
- Enabling and Disabling Rules
- Special Considerations for Procedures Invoked by Rules
- Differences between Rules and Integrity Constraints
- 5
- Defining Transactions
- Understanding ALLBASE/SQL Data Access
- Use of Locking by Transactions
- Defining Isolation Levels between Transactions
- Details of Locking
- What Determines Lock Types
- Scope and Duration of Locks
- Examples of Obtaining and Releasing Locks
- Resolving Conflicts among Concurrent Transactions
- Monitoring Locking with SQLMON
- 6 Names
- 7 Data Types
- 8 Expressions