DB Admin Index

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 messages
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
Appendix A
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