DB Admin Index
**LOAD function
__________more
*CLSE
__________more
*LOAD
*PURG
*READ
*READ, *LOAD
-IFEXIST statement
-IFUNIQUE statement
.DAT file
.IDX file
88-levels
__________more
Abend code
_____DBxx and other CICS-type codes
Abort task
Access methods
ADDIT
Address, setting using MAGECSET
Addresses, setting into pointer
Alternate indices
AMSERV utility
Assigning keys
_____automatically in business rule
Audit
_____stamp
_____stamp
_____stamp
_____stamp
_____stamp
Automatic
_____logical join using Domains
Batch
_____I/O
_____I/O
_____request area
_____security
Batch utility
_____MAGECLBR
BDAM files
__________more
BDAMB files
Block (CI) Size field
Business rules
Business Rules
_____naming conventions
Business rules
_____restrictions
_____screen fields referenced
Business Rules
_____where-used
CA DD Name
Cascade deletion
CICS
_____FCT
_____environment
CLSE
CLSFL
CLSFL, CLOSE commands
Cobol
_____copybook
_____datanames
command sequences
Commands, database
Comp field
Compressed Data
Control
_____file, accessing in business rule
_____record update, on delete
Copybook
__________more
__________more
_____add
_____creating
_____generating
_____modifying
_____name
_____verifying current version
Cross-file / cross-field edits
DAT
Data class
_____definition
_____definition
_____definition screen
_____secondary
Data item
_____definition
_____definition screen
_____definition screen
database error codes
Database ID number
Datacom DB
_____alias key & element names
_____conversion from
_____files
_____files
_____files
_____files
Dataname
_____for a DIT definition
_____where-used
Date
_____fields
DB2
_____generating data definitions
DBDITO function
DBMS return codes
DBUTIL function
DBxx abend code
DCL
_____definition
_____file
_____file
_____file
_____functions
_____key
DCLDOC
DD name
DD Name
_____on PC or LAN
Dec field
Default
_____values, set in database fields
DELET
Delete
_____cascading
_____restriction
Depending On field
Description field
Developer Auth.-Batch field
Distributed data
DIT
_____definition
_____functions
_____moving
_____resequencing
DITxxx functions
_____DITDEL
_____DITDUP
_____DITGEN
_____DITLST
_____DITSEQ
DL/I files
DLBL name
Documentation
_____generation for data
Domain
_____for field-level HELP
_____global changes
_____logical join automation
_____reference in Data Items
_____when adding DIT's
_____where-used
drive ID
_____Network or PC
Dump
Edit type
_____specification in DIT
Editing
_____cross-file / cross-field
Element
_____definition
_____definition
_____definition screen
_____group
_____list
_____name
_____where-used
Element 00
Element 99
__________more
ELT
_____definition
_____file
_____functions
Employee having temporary Exclusive Cont
Error
_____message
error codes
_____database
ESDS files
__________more
Exclusive control of element
FCD
_____file
Field
_____sequence number
Field-level HELP
_____for a table-edited field
File
_____I/O
_____access
_____close
_____initializing
_____open
_____open
_____open
_____support
_____utility
filespec on PC / LAN
FSTAT
Function Codes
_____definition
Group item definition
__________more
Handling errors, database
Hardware failure
Help
_____field-level
_____field-level
_____key
Host Variables
_____generating from DIT definitions
I/O module
IDCAMS
__________more
__________more
IDX
IFEXIST
IFUNIQUE
Initial Value field
ISAM files
__________more
JCL
_____start-up
Just field
Key
_____definition
_____definition
_____definition screen
_____master
_____naming conventions for MAGEC
_____normalization
_____value
Key value
Key-sequenced VSAM
KSDS files
__________more
KSDSU files
KYF
_____definition
_____definition
_____file
_____file
_____functions
_____key
LAN MAGEC
_____data files
LANDRV
_____environment setting
LBRxxx functions
_____LBRSEE
LCLDRV
_____environment setting
Length field
Lgth field
Library
_____member
LOAD
__________more
__________more
Loading addresses into pointers
LOCKX
LOCKY
LOCNX
Logical join
MAGCMPRS
_____files
MAGDBMS
_____batch I/O module
MAGEC
_____dictionary
_____dictionary
MAGECINC
_____conditional
MAGECIO
__________more
__________more
__________more
_____I/O errors
_____calling
_____commands
_____requests
_____requests
MAGECLBR
MAGECSET
MAGECSET subroutine
MAGINIT
__________more
__________more
__________more
__________more
__________more
MAGLOAD
_____jobstream on PC
MAGUNLD
_____jobstream on PC
Master files
Max field
MUxx abend code
Name prefix
Naming conventions
_____MAGEC & Datacom
_____data files on LAN
Network
_____configuration
NH, in database return code
Nullify references
Occurs field
Open
_____for update
_____implicit versus explicit
_____read-only
OPENE, OPENR, OPENO, OPENU, OPENX
Opening files
OPENR
OPENU
PC environment
__________more
PC files
PC MAGEC
__________more
__________more
Pick List
_____for table-edited fields
Production files
Prompt
_____definition in DIT
Pseudodelete
_____purging pseudodeleted records
PURG
Purge
_____pseudodeleted records
_____records from TWA file
RDUID
RDUKY
RDULE
RDUNX
READ
Read-Ahead processing
Redefines field
REDID
REDKY
REDLE
REDNX
REDPR
Referential integrity
_____creating master
_____preventing update
RELES
Req field
Request area
_____batch
Return codes
return codes
_____database
RQ, in TWA-DB-RETURN-CODE
RRDS files
__________more
RULxxx functions
_____RULUSE
_____RULUSE
Sample code
_____batch program
_____online program
SCDxxx functions
_____SCDTBL
Screen field
_____in business rule
_____in business rule
Security
_____batch
SEQDS -or- SEQCMPR files
Sequential files
Sig field
Sign field
SQL
_____table name
SQLGEN
_____generate SQL Host Variables
Standards
Symbolic screen field references
__________more
_____conditional st
Table
_____field-HELP key
_____maintenance
_____where-used
Tbl field
TBLxxx functions
Test files
TOC functions
TP monitor
TWA Clobbered by I/O message
TWA-DB-RETURN-CODE
TWAPUR function
TWAUTIL
Unblocked KSDS
uniform definitions
UPDAT
Variable length records
Version verification
VERZUN function
VM/CMS environment
VSAM
_____files
_____files
_____files
_____files
_____files
_____files
WESTI environment
WESTIFG
Where-used
_____business rule
_____dataname
_____domain
_____element
_____element
_____library menber
_____table number
_____table number
_____tables






Table of Contents
Data Definition Reference Manual
Introduction
__ Who Should Read This Guide
__ Prerequisite Reading
Types of Files Supported
Defining File to TP Monitor
__ PC MAGEC
__ CICS
__ VM/CMS
__ Initializing VSAM Files
Defining the Data Class
__ DCLxxx Functions
__ Datacom/DB
Defining Keys
__ KYFxxx Functions
__ Test
__ Key Normalization
__ PC MAGEC
__ Alternate Indices
__ Key
Defining Elements
__ ELTxxx Functions
__ Variable Length
__ Element 99 Format
Cobol Copybook
__ Copybook for use in MMP's
__ Recommended Standards
Defining Data Items
__ Cobol Datanames
__ Name Prefix
__ ELEMENT Group
__ Date fields
__ Date fields on DIT definition
__ Master Key
__ Creating a Copybook
__ DITxxx Functions
__ DIT Entry Formats
__ 88-levels
__ Exclusive Control of ELT
__ Allowing Multiple Persons Access
__ Group Items
__ Examples of Group Items
__ Moving DIT's
__ Generating the Copybook
__ Resequencing DIT's
__ Modifying Generated Copybook
__ Field-Level HELP
Accessing Files from Programs
__ MAGECIO
__ MAGECIO
__ MAGECIO
__ The Key Value
__ The Key Value
__ Element List
__ Read Into / Write From
__ Read Into / Write From
__ CALL'ing MAGECIO
__ CALL'ing MAGECIO
Return Codes
__ MAGECIO
Sample Code
__ A Cobol Example
__ A Cobol Example
__ Logical Sequences of Commands
Audit Stamps
__ Element 00
File Utility
__ DBDITO Function
Logical Join
__ Secondary Data Classes
Table Maintenance
__ TOCxxx Functions
__ TBLxxx Functions
__ Where-Used
__ Field-level HELP for Table-edited Fields
Initializing Files
__ MAGINIT
Business Rules
__ What is a
__ Defining Business Rules
__ Naming Conventions in Rules
__ Conditional
__ Restrictions
__ Setting Default
__ Preventing
__ Creating
__ Assigning
Referential Integrity
__ Deletion Rules
__ Prevent Deletion (Restrict)
__ Auto Delete (Cascade)
__ Alter References (Nullify)
__ Other Processes
Symbolic Screen Field References
__ In Business Rules
__ Conditional References
Version Verification
__ The VERZUN
Batch I/O Module
__ MAGDBMS
__ File Opens
__ Batch Security
Where-Used Reporting
__ MAGECLBR
__ SCDTBL
__ DCLDOC
__ Business Rules
__ Domains
File Reorganization
__ Mainframe
__ PC
__ TWA File Purge
Domain Definition
__ What is a Domain?
__ DOMxxx Functions
__ Figurative Constants
Compressed Data
__ CICS Abend Codes
__ Error Messages
Appendix B
Appendix C
Appendix D
Appendix E
Appendix F
Appendix G
__
__ Default Opens
__ Explicit Opens
__ Explicit Closes
Appendix H
__ Generic File Names
__ Multiple Concurrent Processing
__ Generic Output Files
__ Generic Name Formats






List of Figures
Figure 01
Figure 02
Figure 03
Figure 04
Figure 05