bdfd1m26 | Database Administration |
Special Characters
A
B
C
D
E
F
G
H
I
K
L
M
N
O
P
Q
R
S
T
U
V
W
Z
Special Characters
A
ACPDB
(1504)
add
blocks to an interleave
(1657)
add current files
using
(1088), (1098)
ADD field location
defined with the RAD parameter
(1415)
ADD/DEL-type files
(1834), (1842)
addressing argument
(1612), (1617)
ADI parameter
(1396)
ADR parameter
(1320), (1806)
ALG parameter
DBDEF statement
(1389)
TPFDF macros (not DBDEF)
(1007), (1020)
algorithm seed
(1032)
algorithm size
defining in the DSECT macro
(1234)
algorithm string size
(1236)
algorithms
basic and B+Tree index support algorithm
#TPFDBFF
(1207)
description
(1184)
character
(1002)
direct translation algorithms
#TPFDB01
(1008), (1186), (1585)
#TPFDB02
(1009), (1187), (1586)
#TPFDB03
(1010), (1188), (1587)
#TPFDB05
(1042), (1579)
#TPFDB06
(1189)
#TPFDB07
(1190)
#TPFDB08
(1191)
#TPFDB09
(1029)
#TPFDB0A
(1192)
#TPFDB0B
(1193)
description
(1173)
the size of the algorithm string
(1235)
for single subfile
(1182), (1204)
hashing
(1028)
hashing algorithms
#TPFDB09
(1196)
#TPFDB0F
(1197)
#TPFDB10
(1199)
description
(1175)
input string for
(1021)
instead of indexing
(1572), (1576)
manipulating the string
(1035)
no-overflow algorithm
#TPFDB0D
(1177), (1200)
description
(1176)
ordinal algorithms
#TPFDB05
(1194)
#TPFDB0C
(1195)
description
(1174)
single-subfile algorithm
description
(1181), (1206)
user-defined
(1591)
user-defined algorithms
creating your own
(1185), (1581)
APL parameter
(1506)
applications
porting
(1773)
ARS parameter
(1243), (1687), (1702)
attribute dependency
(915)
attributes
(903)
common
(954)
dependent
(917)
B
B+Tree indexing
(1160), (1496), (1569)
backward chaining
allowing
(1094)
backward path
(1600)
BASE parameter
(1326)
BASECOD parameter
(1453)
basic indexing
(893), (1291)
begin ordinal
defining in the DSECT macro
(1075)
block header
defining in the DSECT macro
(1226)
block indexing
(1568)
defining in the DSECT macro
(1215)
block references user code
defined with the CEB parameter
(1475)
defined with the CEE parameter
(1479)
block retrieval error user code
defined with the COE parameter
(1488)
block retrieval user code
defined with the COA parameter
(1483)
block size
ALCS
(987)
changing immediately
(1683)
optimum
(1671)
TPF
(985)
blocks
overflow
(1679), (1690), (1696), (1705)
packing limit
(1723)
prime
(1678), (1693)
using pool for overflow
(1732)
BOR parameter
(1245)
C
CBV parameter
(1365), (1805), (1819), (1830), (1840)
, (1850), (1862)
CBV=1, fixed size
ADD/DEL-type file
(1824)
CBV=2, CNT-type files
(1844), (1856)
CBV=3, reference in fixed position
(1868)
CBV=4, variable size
ADD/DEL-type file
(1836)
NAB-type file
(1813)
CDE parameter
(1455)
CDLBL parameter
(1494)
CDO parameter
(1460)
CDR parameter
(1463), (1471)
CEB parameter
(1474)
CEE parameter
(1478)
chain correction
automatic
(1096)
chaining
affecting performance
(990)
automatic
(1772)
pushdown
(1762)
chains
(993)
character algorithms
(1003)
CHK0 parameter
(1308)
CHKF parameter
(1306)
CNT field location
defined with the CPT parameter
(1446)
CNT field size
defined with the FSZ parameter
(1431)
defined with the SSZ parameter
(1450)
CNT parameter
(1439), (1851)
CNT run-time override
defined with the CDR parameter
(1464)
CNT-type files
(1854), (1866)
COA parameter
(1482)
code samples
(1659)
COE parameter
(1487)
CORE parameter
(1330)
core storage
(1780)
CPF parameter
(1491)
CPT parameter
(1445), (1863)
CR0 parameter
(1469), (1485)
CT1 parameter
(1361), (1363)
customer-format files
ADD/DEL-type
fixed-length
(1835)
variable-length
(1843)
CNT-type
(1855), (1867)
general description
(1797)
NAB-type
fixed-length
(1811)
variable-length
(1823)
P-type
(1067)
D
DASD space
(996), (1672)
data
dependency
(933)
duplication
(919), (945), (948), (950), (962)
, (1566)
entities
(902)
grouping
(1592)
inconsistency
(935)
independence
(896)
linking
(1791)
logging
(1746), (1750)
normalization
(911)
organization
(894)
overflow
(1039), (1047)
redundancy
(895)
requirements
(976)
retrieval
(995)
shuffling
(1764)
spreading over LRECs
(1051)
transfer
(988)
data fields
length of
(978)
data level independence (DLI)
(1239)
databases
example design structure
(972)
hierarchical
(899)
relational
(898), (953)
TPFDF
(900)
DB0131
(1238)
DBADD macro
(1665), (1743), (1781)
DBCLS macro
(1716)
DBDEF functions
B+Tree indexing
(1495)
backward index path
(1366)
basic indexing
(1292)
data extraction
(1394)
default keys
(1282)
forward index path
(1293)
global DSECT overrides
(1241)
miscellaneous
(1502)
TPFDF recoup
(1296), (1798), (1814), (1825), (1837)
, (1845), (1857)
See also DBDEF functions, forward index path
TPFDF recoup user exits
(1451)
DBDEF parameters
#IT=-1
(1297)
ACPDB
(1503)
ADI
(1395)
ADR
(1319), (1800)
ALG
(1388)
APL
(1505)
ARS
(1242), (1685), (1700)
BASE
(1325)
BASECOD
(1452)
BOR
(1244)
CBV
(1364), (1799), (1815), (1826), (1838)
, (1846), (1858)
CDE
(1454)
CDLBL
(1493)
CDO
(1459)
CDR
(1462), (1470)
CEB
(1473)
CEE
(1477)
CHK0
(1307)
CHKF
(1305)
CNT
(1438), (1847)
COA
(1481)
COE
(1486)
CORE
(1329)
CPF
(1490)
CPT
(1444), (1859)
CT1
(1360), (1362)
DDA
(1507)
DELEMPTY
(1511)
DEV
(1513)
DID
(1390)
DIS
(1331)
DIT
(1323)
EO
(1248)
EOR
(1246)
FIELD
(1327)
FNR
(1406), (1520)
FSZ
(1428)
FVN
(1404), (1515)
GREG
(1522)
ID1=(NORECOUP)
(1294)
ID2
(1301)
ID3
(1303)
IFR
(1392)
IID
(1367)
IKY
(1374)
ILA
(1378), (1609), (1614)
ILK
(1382)
ILV
(1250)
IMI
(1371)
INB
(1333)
INDEX
(1315)
IPA
(1376), (1608), (1613)
IPE
(1384)
IPK
(1380)
ISZ
(1435)
ITK
(1299)
ITS
(1419), (1803), (1829), (1848), (1860)
KEY
(1386)
KEYCHECK
(1528)
KEYn
(1287)
LDI
(1397)
LEV
(1335)
LLE
(1399)
MDBF
(1545)
MPFSTD
(1337)
MPNXST
(1339)
MPPRCD
(1341)
MPRECD
(1343)
NAB
(1422), (1801), (1816)
NLR
(1252)
NOC
(1254)
NODE
(1498)
NODEID
(1500)
NORECOUP
(1309)
OP1
(1256)
OP2
(1258)
OP3
(1260)
ORD
(1311)
ORG
(1285)
PACKINHI
(1530)
PF0
(1532)
PF1
(1534)
PF2
(1536)
PFC
(1345), (1804)
PIN
(1262), (1726)
PIS
(1432), (1818), (1839)
PIT
(1441), (1849), (1861)
PKY
(1283)
PLI
(1538), (1718), (1737), (1740)
PNB
(1425), (1802), (1817)
PTH
(1369)
PTN
(1265)
QUE
(1347)
R
(1289)
RAD
(1413), (1827)
RBV
(1267)
RCI
(1313), (1349)
RCO
(1401), (1408)
RCP
(1321)
RCT
(1269)
RDE
(1416), (1828)
RECOUP
(1351)
RFC
(1354)
RID
(1317)
SIZECHK
(1541)
SKE
(1271)
SSU
(1543)
SSZ
(1447)
STP
(1356)
SUFFIX
(1550)
TIMEOUT
(1358)
TM
(1555)
TQK
(1274)
TRS
(1557)
TYP
(1276)
UNIQUE
(1559)
WID
(1278)
WRS
(1280), (1686), (1701)
DBDEL macro
packing a file
(1118)
packing before deleting
(1509)
packing files using
(1712), (1729)
DBDIX macro
(959), (970)
DBDSP macro
displaying LRECs in any order
(1787)
DBIDX macro
(958), (971)
DBMOD macro
corrupting file organization
(1525)
DBOPN macro
defaulting to DETAC mode
(1163)
opening a W-type file
(1774)
opening with DETAC parameter
(1777)
using the HOLD parameter
(1138), (1142), (1146)
using the PARTITN parameter
(1647)
using the TAPE parameter
(1748)
DBRED macro
fast access
(1757)
using the BACKWARD parameter
(1092)
DBREP macro
corrupting file organization
(1524)
packing a file
(1116)
packing files using
(1730)
DBRST macro
sequence parameters
(1121)
DBUKY macro
&SW00OP1 bit 4
(1106)
checkpoint when using
(1105)
enabling
(1166)
DDA parameter
(1508)
defining multiple structures in the same file
(1403)
DEL field location
defined with the RDE parameter
(1418)
DELEMPTY parameter
(1512)
dependency
direct
(927)
indirect
(928)
transitive
(929)
DEV parameter
(1514)
dfadd function
(1666), (1744), (1782)
dfdel function
packing a file
(1119)
packing before deleting
(1510)
dfdsp function
displaying LRECs in any order
(1788)
dfmod function
corrupting file organization
(1526)
dfopn function
defaulting to DETAC mode
(1164)
opening with DETAC parameter
(1778)
using the HOLD parameter
(1139), (1143), (1147)
dfopt function
using the PARTITION option
(1648)
dfred function
fast access
(1758)
using the BACKWARD parameter
(1093)
dfrep function
corrupting file organization
(1527)
packing a file
(1117)
packing files using
(1731)
dfrst function
sequence parameters
(1122)
dfuky function
&SW00OP1 bit 4
(1108)
checkpoint when using
(1107)
enabling
(1167)
diagrams for macro models
(892)
DID parameter
(1391)
direct dependency
(930)
DIS parameter
(1332)
DIT parameter
(1324)
DLI
(1240)
See also data level independence (DLI)
DSECT macro
algorithm size
(1233)
block header
(1225)
coding for interleaved files
(1654)
creating
(1057), (1059)
ending statements
(1237)
file description
(1223)
global set symbols
(1070)
LREC IDs
(1228)
LREC size
(1227)
LREC user fields
(1231)
modifying sample DSECT macros
(1068)
naming
(1069)
samples
(1058)
duplicate labels
SUFFIX parameter
(1553)
duplication of data
(920), (946), (949), (951), (963)
E
EBCxxx
CR0
(1468), (1484)
FA0
(1456), (1461), (1476), (1480), (1489)
FA1
(1457), (1458)
end ordinal
defining in the DSECT macro
(1077), (1079)
entities
(901)
EO
(1249)
EOR parameter
(1247)
extended LRECs
See also LRECs
defining
(1151)
F
field length
expanding
(979)
FIELD parameter
(1328)
fields
(904)
file accesses
reducing
(1565), (1573)
file description
defining in the DSECT macro
(1224)
file ID
defining in the DSECT macro
(1221)
file name
convention
(1061)
defining in the DSECT macro
(1082)
defining using DSECT name default
(1060), (1066)
file type
defining in the DSECT macro
(1219)
file versions
FNR parameter
(1411), (1519)
FVN parameter
(1410), (1517)
files
combining
(1567), (1574)
expanding
(1038), (1046)
fixed
(1691)
index
(968)
integrity of
(1660)
interrogating
(1040)
loading from tape
(1134)
miscellaneous
(1037)
organization of
(1662), (1697)
packing
(1114), (1128)
referencing
(1598)
regular packing of
(1711)
restoring
(1131)
updating with 2 ECBs
(1137), (1148)
first normal form
(913), (937)
fixed file type
defining in the DSECT macro
(1209)
fixed files
(1692)
fixed-length DBDEF parameter
(1812)
fixed-length LRECs
See also LRECs
algorithm for
(1178), (1201)
defining the number per block in the DSECT macro
(1086)
FNR parameter
(1407), (1518), (1521)
forward chain field location
defined with the CPF parameter
(1492)
forward path
(1599)
FSZ parameter
(1429)
FVN parameter
(1405), (1516)
G
GETCC
(1767)
global set symbols
defining in the DSECT macro
(1071)
GREG parameter
(1523)
GW01SR
(1783)
H
hashing algorithms
(1027)
highest LREC ID for TPFDF
defining in the DSECT macro
(1217)
I
I/O processing
reducing
(1049), (1563), (1594), (1597), (1623)
, (1633), (1673)
ID1=(NORECOUP) parameter
(1295)
ID2 parameter
(1302)
ID3 parameter
(1304)
IFR parameter
(1393)
IID parameter
(1368)
IKY parameter
(1375)
ILA parameter
(1379), (1611), (1616)
ILK parameter
(1383)
ILV parameter
(1251)
IMI parameter
(1372)
IMI=
(1373)
INB parameter
(1334)
index files
(969)
index keys
example
(1017)
translating
(1578)
index LRECs
checkpoint when adding
(1157)
checkpoint when deleting
(1158)
example
(1603)
INDEX parameter
(1316)
indexed fixed files
defining
(1155)
indexing
See also PARM
B+Tree
(1161), (1497), (1571), (1630)
block
(1570), (1620)
multiple
(1604)
multiple-level
(1607)
simple
(1601)
single
(1618)
to multiple detail files
(1619)
indirect dependency
(931), (940)
interleave
adding blocks to
(1656)
benefits of using
(1653), (1658)
coding the DSECT
(1655)
example of
(1640), (1651)
interleaved files
defining in the DSECT macro
(1084)
IPA parameter
(1377), (1610), (1615)
IPE parameter
(1385)
IPK parameter
(1381)
ISZ parameter
(1436)
item count
defined with the CNT parameter
(1440)
item position
defined with the PIT parameter
(1443)
item size
defined with the ITS parameter
(1421)
item size field
defined with the ISZ parameter
(1437)
item size location
defined with the PIS parameter
(1434)
ITK parameter
(1300)
ITS parameter
(1420), (1809), (1833), (1852), (1864)
K
key parameters
specifying
(1288), (1387), (1661)
KEYCHECK parameter
(1529)
keys
index
(1018), (1577)
partial
(1668)
primary
(914), (926)
unique
(1795)
update
(1664)
L
LDI parameter
(1398)
leap years
(977), (1045)
LEV parameter
(1336)
links
(955), (957)
LLE parameter
(1400)
log files
maintaining
(1749)
using
(1090), (1100)
logical data groups
(1593)
LREC contents
(1792)
LREC fields
key
(1024)
size
(1023)
LREC ID
defining in the DSECT macro
(1230)
description
(925)
LREC keys
unique
(1629), (1638)
LREC size
defining in the DSECT macro
(1229)
LREC structure
(1041)
LREC types
(1768), (1793)
LREC user fields
defining in the DSECT macro
(1232)
LRECs
See also extended LRECs
calculating required number of
(983)
displaying order for
(1786)
distribution of
(1014)
alphabetic
(1001)
even
(997), (1004)
numerical
(1025)
pseudo-random
(1026)
uneven
(1584)
expansion of
(980)
fixed-length
(1180), (1203)
index
(1602)
organization of
(1628), (1637), (1756)
scattered over blocks
(1722)
spreading over blocks
(1052)
variable length
(981), (1053)
M
macro model diagrams
(891)
macro parameters (non-DBDEF)
ALG
(1006), (1019)
PARTITN
(1649)
macros
See also DBADD, DBCLS, DBDEL, DBDIX, DBDSP, DBIDX, DBMOD, DBOPN, DBRED, DBREP, DBRST, DBUKY
DBDEF
(1056)
DSECT
(1055)
mapping
logical to physical
(974)
rows to LRECs
(907)
tables to files
(906), (975)
MDBF
defining overrides in a file
(1547)
defining SSUs
(1549)
multiple definitions
(1548)
MDBF parameter
(1546)
models of macro invocations
(888)
MPFSTD parameter
(1338)
MPNXTD parameter
(1340)
MPPRCD parameter
(1342)
MPRECD parameter
(1344)
N
NAB
defined with the NAB parameter
(1424)
NAB field location
defined with the PNB parameter
(1427)
NAB field size
defined with the FSZ parameter
(1430)
defined with the SSZ parameter
(1449)
NAB parameter
(1423), (1807), (1820)
NAB run-time override
defined with the CDR parameter
(1466)
next available byte (NAB)
validating
(1125)
NLR parameter
(1253)
no overflow, algorithm for
(1179), (1202)
NOC parameter
(1255)
NODE parameter
(1499)
NODEID parameter
(1501)
non-TPFDF files
(1353), (1796)
NOPACK
(1715)
NORECOUP parameter
(1310)
normalization
first normal form
(908), (936)
second normal form
(909), (938)
third normal form
(910), (943)
O
OP1 parameter
(1257)
OP2 parameter
(1259)
OP3 parameter
(1261)
optimization
(960), (1562)
optional trailers
(986)
ORD parameter
(1312)
ordinals
algorithms for locating
(1583)
preventing large overflows
(1575)
retrieving
(1044)
ORG parameter
(1286)
overflow
reducing
(1717)
overflow blocks
affecting performance
(991), (1000)
changing size of
(1036), (1048), (1670)
checking utilization of
(1674)
defining the size in the DSECT macro
(1073)
defining variable sizes in the DSECT macro
(1110)
holding
(1141), (1145)
limiting
(1089), (1099)
processing
(1710)
reducing number of
(1689), (1695)
releasing on pack
(1127)
releasing on restore
(1130)
releasing on tape load
(1133)
setting different sizes for
(1680), (1704)
using pool for
(1733)
P
P-type files
define using DSECT name default
(1064)
PACK parameter
(1713), (1735)
packing a file
(1714)
packing limit
default values
(1745)
PLI parameter
(1540), (1719), (1738), (1741)
processing overhead
(1724)
packing threshold
defined with the PIN parameter
(1264)
defining in the DSECT macro
(1169)
PACKINHI parameter
(1531)
partial keys
(1669)
partial update paths
(1606)
partition
benefits of using
(1643)
example of
(1639), (1644)
partitioned files
algorithm for
(1198)
partitions
accessing
(1646)
adding
(1650)
coding the DSECT
(1645)
defining in the DSECT macro
(1171)
performance
block indexing
(1760)
block size
(989)
duplicating data
(964)
improving access
(966), (1754)
overflow blocks
(992), (1675)
pointers
(1759)
reducing I/O
(1050), (1564), (1595), (1596), (1622)
, (1632)
retrieval speed
(961)
spreading data
(1054)
updating
(1621), (1631), (1755)
PF0 parameter
(1533)
PF1 parameter
(1535)
PF2 parameter
(1537)
PFC parameter
(1346), (1810)
PIN parameter
(1263), (1727)
PIS parameter
(1433), (1822), (1841)
PIT parameter
(1442), (1853), (1865)
PIT run-time override
defined with the CDR parameter
(1467), (1472)
PKY parameter
(1284)
PLI parameter
(1539), (1720), (1739), (1742)
PNB parameter
(1426), (1808), (1821)
PNB run-time override
defined with the CDR parameter
(1465)
pointers
(956), (967), (1016)
pool blocks
using for overflow
(1734)
primary key
B+Tree indexing
(1634)
block indexing
(1625)
in normalization
(921)
TPFDF LREC ID
(924)
unique value of
(922), (941)
prime blocks
changing size of
(1694)
holding
(1136)
setting the size
(999), (1677)
prime numbers
(1033)
PTH parameter
(1370)
PTN parameter
(1266)
pushdown chaining
improving data access
(1761)
using
(1103)
Q
QUE parameter
(1348)
queries
example
(965)
R
R parameter
(1290)
R-type files
define using DSECT name default
(1065)
getting working storage
(1789)
RAD parameter
(1414), (1831)
railroad tracks
(889)
RBV parameter
(1268)
RCC parameter
(1627), (1636)
RCIDID parameter
(1314), (1350), (1605)
RCO parameter
(1402), (1409)
RCP parameter
(1322)
RCT parameter
(1270)
RDE parameter
(1417), (1832)
record code check
(1626), (1635)
records
pool
(1771)
recoup concatenation order
RCO parameter
(1412)
RECOUP parameter
(1352)
relational databases
(897), (952)
relations
(912)
RFC parameter
(1355)
RID parameter
(1318)
row size
(934)
rows
identifying
(923)
S
SAPR
(1676)
second normal form
(916), (939), (942)
seed
(1031)
sequence update counter
(1123)
single-subfile algorithm
(1183), (1205)
SIZECHK parameter
(1542)
SKE parameter
(1272)
specifying block indexing
(1273)
SSU parameter
(1544)
SSZ parameter
(1448)
storage
core constraints
(1779)
working
(1765)
STP parameter
(1357)
subfiles
accessing
(1022)
calculating required number of
(984), (994)
contents of
(998)
packing
(1721), (1728)
size of
(1706)
specifying the number of
(1034)
system
(1707)
SUFFIX parameter
(1551), (1552), (1554)
SW00
EO
(1642)
ILV
(1652)
PTN
(1641)
syntax diagrams
(890)
system subfiles
(1708)
T
T-type files
define using DSECT name default
(1062)
defining in the DSECT macro
(1213)
getting working storage
(1770), (1785)
tables
mapping
(905), (973)
tape logging
(1747)
third normal form
(918), (944), (947)
TIMEOUT parameter
(1359)
TLRECs
(1624)
TM parameter
(1556)
TPFDF recoup
defining the end ordinal in the DSECT macro
(1080)
TQK parameter
(1275)
transitive dependency
(932)
TRS parameter
(1558)
TYP parameter
(1277)
U
UF0H
(1776)
unique keys
(1794)
UNIQUE parameter
(1560), (1561)
update keys
(1663)
UWBD user exit
creating your own algorithm
(1015), (1582)
V
variable-length LRECs
(982)
W
W-type files
define using DSECT name default
(1063)
defining in the DSECT macro
(1212)
getting working storage
(1769), (1784), (1790)
opening
(1775)
WID parameter
(1279)
work area reference name
defining in the DSECT macro
(1211)
working storage
(1766)
wraparound
(1751)
WRS parameter
(1281), (1688), (1703)
Z
ZUDFM
(1667)
ZUDFM OAP
(1684)