TurboIMAGE/XL Database Management System Reference Manual (30391-90012)
Table Of Contents
- 1 Introduction
- 2 Database Structure and Protection
- 3 Defining a Database
- 4 Using the Database
- 5 TurboIMAGE/XL Library Procedures
- Using TurboIMAGE/XL Intrinsics
- DBBEGIN
- DBCLOSE
- DBCONTROL
- DBDELETE
- DBEND
- DBERROR
- DBEXPLAIN
- DBFIND
- DBGET
- DBINFO
- INTRINSIC NUMBER 402
- Syntax
- Parameters
- Discussion
- Mode 101: Item Number
- Mode 102: Item Name
- Mode 103: Items in Database
- Mode 104: Items in Data Set
- Mode 113: BTREEMODE1 and Wildcard Character
- Mode 201: Set Number
- Mode 202: Set Name
- Mode 203: Sets in Database
- Mode 204: Sets with Item
- Mode 205: Set Capacity
- Mode 206: Number of Data Set Chunks
- Mode 207: Size of Data Set Chunks
- Mode 208: Primary and Actual Capacity
- Mode 209: B-Tree Attachment
- Mode 301: Paths
- Mode 302: Key or Search Item
- Mode 401: Logging
- Mode 402: ILR
- Mode 403: Dynamic Roll-Back
- Mode 404: Logging Subsystem Information
- Mode 406: Database Information
- Mode 501: Subsystem Access
- Mode 502: Critical Item Update
- Modes 8nn: Third-Party Indexing
- Mode 901: Language
- DBLOCK
- DBMEMO
- DBOPEN
- DBPUT
- DBUNLOCK
- DBUPDATE
- DBXBEGIN
- DBXEND
- DBXUNDO
- 6 Host Language Access
- Model Program
- ORDERS Database Model Program
- Main Body of Program
- Opening the Database
- Retrieving All the Records on a Chain (with Item Level Locking)
- Retrieving a Data Entry Using a Record Number
- Retrieving Master Data Using a Key Value
- Retrieving Data Serially (with Set Level Locking)
- Adding an Entry
- Updating an Entry
- Deleting an Entry
- Rewinding a Data Set
- Obtaining Database Information
- Obtaining Error Messages and Explanations
- Closing the Database
- C
- COBOL II
- Defining Data Types, Variables, and Intrinsics
- Main Body of Program
- Opening the Database
- Retrieving All the Records on a Chain (with Item Level Locking)
- Retrieving a Data Entry Using a Record Number
- Retrieving Master Data Using a Key Value
- Retrieving Data Serially (with Set Level Locking)
- Adding an Entry
- Updating an Entry
- Deleting an Entry
- Rewinding a Data Set
- Obtaining Database Information
- Obtaining Error Messages and Explanations
- Closing the Database
- FORTRAN 77
- Pascal
- RPG
- 7 Logging and Recovery
- Database Utilities Used in Logging and Recovery
- Recovery Options
- Logical Transactions
- Dynamic Roll-Back Recovery
- Intrinsic Level Recovery
- Logging Preparation
- Step 1--Checking MPE/iX Logging Configuration
- Step 2--Acquiring Logging Capability
- Step 3--Logging to Tape or Disk
- Step 4--Building a Log File for Logging to Disk
- Step 5--Creating the Log Identifier
- Step 6--Setting the Log Identifier
- Step 7--Setting Flags for the Database Backup Copy
- Step 8--Making a Database Backup Copy
- TurboSTORE/iX 7x24 True-Online Backup
- Logging Status
- Logging Maintenance
- Roll-Forward Recovery
- Roll-Back Recovery
- DBRECOV Commands Used with Roll-Forward and Roll-Back Recovery
- Recovery Tables
- Post-Recovery Options
- The Mirror Database
- 8 Using the Database Utilities
- Restructuring the Database with TurboIMAGE/XL Utilities
- Summary of Utility Routines
- Utility Program Operation
- DBLOAD
- DBRECOV
- >CONTROL
- >EXIT
- >FILE
- >RECOVER
- >ROLLBACK
- >RUN
- DBRESTOR
- DBSTORE
- DBUNLOAD
- DBUTIL
- >>ACTIVATE
- >>ADDINDEX
- >>CREATE
- >>DEACTIVATE
- >>DETACH
- >>DISABLE
- >>DROPINDEX
- >>ENABLE
- >>ERASE
- >>EXIT
- >>HELP
- >>MOVE
- >>PURGE
- >>REBUILDINDEX
- >>REDO
- >>RELEASE
- >>SECURE
- >>SET
- >>SHOW
- Syntax
- Parameters
- Example (Show Users)
- Example Discussion
- Example (Show All)
- Example Discussion
- Example (Show Capacity)
- Format of Show Device List
- Example (Show Device)
- Format of Show Indices
- Example (Show Indices)
- Format of Show Locks List
- Example 1 (Show Locks)
- Example 1 Discussion
- Example 2 (Show Locks)
- Example 2 Discussion
- >>VERIFY
- 9 Using a Remote Database
- 10 Internal Structures and Techniques
- 11 B-Tree Indices
- A Error Messages
- B Results of Multiple Access
- C Database Design Considerations
- D Multiple Calls to DBLOCK
- E TurboIMAGE/XL Log Record Formats
- F MPE/iX Log Record Formats
- G Recovery and Logging Quick Reference
- H TurboIMAGE/XL versus TurboIMAGE/V

Tables
21
Table 2-1.. Manual and Automatic Masters. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 40
Table 2-2.. Sample Read/Write Class Lists . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 53
Table 2-3.. Enabling a User Class to Perform a Task . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 55
Table 2-4.. Sample Read and Write Class Lists. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 58
Table 3-1.. Additional Conventions . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 62
Table 3-2.. Type Designators. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 66
Table 3-3.. TurboIMAGE/XL Data Types and Programming Languages . . . . . . . . . . . . . 67
Table 3-4.. Examples of an Item Part. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 70
Table 3-5.. Schema Processor Files. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 78
Table 3-6.. Examples of RUN and FILE Commands. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 79
Table 3-7.. Data Set Summary Table Information. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 87
Table 4-1.. Library Procedures DBOPEN Modes. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 96
Table 4-2.. Database Access Mode Summary. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 96
Table 4-3.. Logged Intrinsics. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 100
Table 4-4.. Locking in Shared-Access Environments . . . . . . . . . . . . . . . . . . . . . . . . . . . . 123
Table 4-5.. Types of Logical Transactions . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 127
Table 5-1.. TurboIMAGE/XL Procedures . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 136
Table 5-2.. Calling a TurboIMAGE/XL Procedure. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 137
Table 5-3.. Types of Transactions. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 138
Table 5-4.. DBBEGIN Return Status Values. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 141
Table 5-5.. DBCLOSE Modes 2 and 3 Functions. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 144
Table 5-6.. DBCLOSE Return Status Values. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 145
Table 5-7.. DBCONTROL Return Status Values. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 151
Table 5-8.. DBDELETE Return Status Values . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 155
Table 5-9.. DBEND Return Status Values. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 160
Table 5-10.. DBERROR Messages . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 162
Table 5-11.. DBEXPLAIN Message Format. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 176
Table 5-12.. DBFIND Return Status Values . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 183
Table 5-13.. DBGET Return Status Values . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 188
Table 5-14.. DBINFO Return Status Values . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 191
Table 5-15.. Locking Mode Options . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 208
Table 5-16.. Lock Descriptor Fields . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 210
Table 5-17.. DBLOCK Return Status Values. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 212
Table 5-18.. DBMEMO Return Status Values . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 215
Table 5-19.. DBOPEN Return Status Values. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 220
Table 5-20.. Special list Parameter Constructs . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 224
Table 5-21.. DBPUT Return Status Values . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 227
Table 5-22.. DBUNLOCK Return Status Values. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 231
Table 5-23.. DBUPDATE Return Status Values . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 234