Data Definition Language (DDL) Reference Manual (G06.24+)

Data Definition Language (DDL) Reference Manual—426798-002
Index-1
Index
Numbers
66 RENAMES clause
DEFINITION statement 5-9
RECORD statement 5-21
syntax 6-85
88 condition-name clause
and SQL data types 6-83
and SQLNULLABLE clause 6-40
DEFINITION statement 5-8
RECORD statement 5-20
syntax 6-86
89 enumeration clause
and SQL data types 6-83
and SQLNULLABLE clause 6-40
DEFINITION statement 5-8
RECORD statement 5-21
syntax 6-89
A
ALL literal
MUST BE clause 6-17
VALUE clause 6-80
Alternate key
allowing duplicates 5-22, 6-13
defining with KEYTAG clause 5-19,
6-13
null value 6-20
Arrays
C lower bound 9-9
OCCURS DEPENDING ON
clause 6-24
Pascal lower bound 9-87
TAL lower bound 9-107
AS clause
DEFINITION statement 5-6
RECORD statement 5-19
syntax 6-3
Assigned file 5-14
ASSIGNED file attribute 5-14
Asterisk
OUTPUT statement 8-6
TYPE clause 6-50
Attributes
definition 6-1
file creation 5-14
AUDIT file attribute 5-15
Audit trail compression 5-15
AUDITCOMPRESS file attribute 5-15
Audited dictionary
moving to another subvolume 10-15
rebuilding 10-21
Audited file, creating 5-15
B
Backup schema
creating 1-10
uses for 10-1
BEGIN
DEFINITION statement 5-6
requirements for use of 5-2
Binary data definition
PICTURE clause 6-26
TYPE clause 6-48
BIT data type
and SQLNULLABLE clause 6-40
data definition 6-54
TYPE clause 6-50
BLOCK file attribute 5-15
Block size 5-15
Buffer size specification 5-15
BUFFERED file attribute 5-15
BUFFERSIZE file attribute 5-15