The listed publications in this section are available individually or can be purchased as part of a 'Publication Set' offering price savings over the individual cost of each publication within the set.
The following publications apply to the Software AG database product ADABAS.
All publications listed can be purchased using the books order form.
|
238 pages Copyright © 2004 by WH&O International. SOFTWARE AG, the SOFTWARE AG logo, ADABAS, NATURAL and ENTIRE are registered trademarks and ESPERANT is a trademark of SOFTWARE AG. All other products named are trademarks of their respective owners. |
For the applications programmer or designer, this book offers valuable and clear information concerning those aspects of ADABAS important to applications development. Whether you are working on a small prototype, a file design or a large database, this manual is an excellent resource.
This is not an internals manual. It is simply designed to introduce programmers, analysts, and designers to the functions and facilities of ADABAS with practical exercises emphasising the various strengths of ADABAS.
DBMS Overview
* DBMS Concepts and Facilities * Introduction to the Guide * Advantages of Data Base Management Systems.
The ADABAS Data Base: ADABAS Environment
* The Associator and It’s Structure * Work Data Set * Data Storage: Format and Management * Protection Log: Before and After Imaging * Command Log: ADABAS Command Summary.
Data Storage
* ADABAS Extents/Blocks * Record and Field Formats * Data Compression * Multiple Value fields * Periodic Groups.
ADABAS Associator
* Control Block Overview * File Management Field Definition Table: Syntax, Usage and Super/Sub Descriptor Convention Address Converter * Normal Index (Inverted Lists).
Descriptor Usage
* Advantages, Disadvantages, Considerations * Descriptor Types * Normal * Unique Superdescriptor * Subdescriptor * Phonetic Descriptor * Hyperdescriptor.
Using the Associator & Data Storage
* Access Paths * Superfields * Subfields * Walkthrough: Associator; Address Converter; Data Storage * Building a Normal Index Logically * Linking Normal Indexes * Address Converter.
Inter-region Communication
* Host Operating System Environment * Application Interface * Control Block * Search Buffer * Value Buffer * Format Buffer * Record Buffer * ISN Buffer.
ADABAS Nucleus Overview
* User Queue * Command Queue * Threads * Hold Queue * Buffer Pool * Internal Format Buffer, Work Buffer Pool.
Command Overview
* READ Commands * READ BY ISN * READ IN PHYSICAL SEQUENCE * READ IN LOGICAL SEQUENCE * READ Associator * Superfields and Subfields * FIND Commands * FIND ISN’s * FIND SORTED * Search Algorithms * Sort Algorithms * Database Modification Commands * Change Record * Delete Record * Add Record * Logical Transaction Control Commands * END OF TRANSACTION * BACKOUT TRANSACTION.
ADAM Processing
* ADAM File Definition Unique Descriptor * Estimation Utility Advantages and Disadvantages.
Accessing ADABAS
* Direct Calls * ADAMINT * NATURAL * ADASQL.
ADABAS Utilities Overview
* File Definition, Loading and Modification * ADAMER * ADAWAN * ADALOD * ADABAS Database Modification * ADAVUS * ADADBS * ADAINV * File Unload and Decompression * ADAULD * ADACMP * ADABAS Backup and Recovery * ADASAV * ADAORD * ADARES * ADABAS Reporting and Tuning * ADAREP * ADAPRI * ADAPLP, Print Protection Log Review of Performance Monitoring Tools.
Restart Recovery
* Checkpointing * Protection Log * TP Recovery Log * Utilities * Exclusive and Cluster Control * User Program Control Security * ADABAS Security * Password Security by File Password Security by Field * Password Security by Value * Ciphering * NATURAL Security * User Generated Security Data Dictionary ADAWAN * Field Definition Table (FDT) * Data Definition Module (DDM0 * Predict.
Appendix
* Quiz: Test Your ADABAS Knowledge * Glossary of ADABAS Terms.
Introduction to Programming with ADASQL
ADASQL Basics
* BEGIN * CONNECT * COPY * CLOSE * Record Buffer * ISN Buffer.
Accessing the Database with ADASQL
* EXEC ADABAS * FIND * READ PHYSICAL SEQUENCE * READ LOGICAL * READ ISN * HISTOGRAM * DELCARE Clause * SELECT Clause * FROM Clause * WHERE Clause * OPTIONS Clause * ORDER BY, GROUP BY Clause * OPEN, FETCH, CLOSE Statements.
Logical Transactions
* DELETE, INSERT, UPDATE Statements * COMMIT WORK, ROLLBACK WORK Statements.
Additional ADASQL Statements
* READ USERDATA * CHECKPOINT * HOLD * RELEASE * RELEASE ISN * SAVE * RESTORE * TRACE * WRITE TO LOG Statement Internal Error Checking * Response Codes.
Direct Call Programming
Communications Areas
CONTROL BLOCK * FORMAT BUFFER * RECORD BUFFER * Calling ADABAS * SEARCH BUFFER * VALUE-BUFFER * ISN BUFFER * Control Block: Command Code, Command ID * File Number * Response Code ISN * Format Buffer Length * Record Buffer Length * Search Buffer Length * Value Buffer Length * ISN Buffer Length * Command Options * Addition Options * Command Time * User Area.
Basic Access Commands
* OPEN * CLOSE * Search Buffer Use and Considerations * Using the Value Buffer * S1/S4 (FIND) * Format Buffer Syntax Periodic Group Specification * Multiple Value Field Specification * Ranges of Fields * Length and Format Specifications * Performance Considerations.
Read Commands
L1/L4 (READ BY ISN) * L2/L5 (READ PHYSICAL) * L3/L6 (READ LOGICAL) * Summary of READs * GET NEXT Processing.
Modifying the Database
* N1/N2 (STORE) * Format Buffer and Record Buffer Considerations * A1/A4 (UPDATE) * E1/E4 (DELETE) * ET (END TRANSACTION) * BT (BLACKOUT TRANSACTION).
Miscellaneous ADABAS Commands
* L9 (READ ASSOCIATOR/HISTOGRAM) * HI (HOLD ISN) * LF (LIST FILE) * RC (RELEASE COMMAND ID) * RE (READ USER DATA) * RI (RELEASE ISN).
[Back to the top] [back to index] [previous] [order]