HP DDL D40 User manual

Data Definition
Language (DDL)
Reference Manual
Abstract
This manual describes the DDL language syntax and the DDL dictionary database.
The audience includes application programmers and database administrators.
Product Version
DDL D40
Supported Release Version Updates (RVUs)
This publication supports G02.00 and all subsequent G-series RVUs until otherwise
indicated by its replacement publication.
Part Number Published
426798-002 November 2004

Document History
Part Number Product Version Published
098209 DDL D20 September 1993
105918 DDL D30 December 1994
122316 DDL D40 November 1995
426798-001 DDL D40 October 2000
426798-002 DDL D40 November 2004

Hewlett-Packard Company—426798-002
i
Data Definition Language (DDL)
Reference Manual
Glossary Index Figures Tables
What’s New in This Manual xi
Manual Information xi
New and Changed Information xi
About This Manual xiii
Audience xiii
Organization of This Manual xiii
Prerequisite Manuals xiv
Related Manuals xv
Notation Conventions xv
1. Introduction to DDL
Compiling and Translating Data Definitions 1-1
Using DDL Definitions 1-2
Creating a Dictionary 1-4
Creating a Database 1-5
Generating Source Code 1-7
Maintaining a Dictionary 1-10
Examining a Dictionary 1-11
2. DDL Language Elements
DDL Names 2-1
DDL File Names 2-2
Local File Names 2-2
DDL Locale Names 2-4
DDL Numbers 2-5
DDL Strings 2-5
DDL Keywords and Reserved Words 2-6
DDL Keywords 2-6
DDL Reserved Words 2-7
DDL Special Characters 2-8
DDL Comments 2-9
Dictionary Comments 2-9

Contents
Data Definition Language (DDL) Reference Manual—426798-002
ii
3. Running the DDL Compiler
Compiler Listing Comments 2-11
DDL Statements 2-12
DDL Compiler Commands 2-13
3. Running the DDL Compiler
DDL Run Command 3-1
Running DDL in Noninteractive Mode 3-2
Running DDL in Interactive Mode 3-3
Completion Code Processing 3-5
4. Named Constants
CONSTANT Statement 4-1
Standard SPI Constants 4-9
5. Definitions and Records
DEFINITION and RECORD Statements 5-1
DEFINITION Statement 5-1
Forms of the DEFINITION Statement 5-1
Exceptions for Specifying Definition Clauses 5-2
Field Definition Syntax 5-3
Group Definition Syntax 5-4
Reference Definition Syntax 5-5
Syntax Elements 5-5
Definition Error Handling 5-11
RECORD Statement 5-12
Parts of the RECORD Statement 5-12
File-Creation Syntax 5-14
Reference Record Structure Syntax 5-17
Record Structure Syntax 5-18
Key Assignment Syntax 5-21
RECORD Statement Error Handling 5-27
6. Definition Attributes
AS Clause 6-3
DISPLAY Clause 6-4
EDIT-PIC Clause 6-5
EXTERNAL Clause 6-7
FILLER Clause 6-8
HEADING Clause 6-9
HELP Clause 6-11

Contents
Data Definition Language (DDL) Reference Manual—426798-002
iii
7. SPI Tokens
JUSTIFIED Clause 6-12
KEYTAG Clause 6-13
LN Clause 6-14
MUST BE Clause 6-16
NULL Clause 6-20
OCCURS Clause 6-21
OCCURS DEPENDING ON Clause 6-24
PICTURE Clause 6-26
REDEFINES Clause 6-32
SPI-NULL Clause 6-35
SQLNULLABLE Clause 6-38
TACL Clause 6-44
TYPE Clause 6-47
UPSHIFT Clause 6-73
USAGE Clause 6-74
VALUE Clause 6-79
66 RENAMES Clause 6-85
88 Condition-Name Clause 6-86
89 Enumeration Clause 6-89
7. SPI Tokens
SPI Token Definition 7-1
DDL Token-Definition Statements 7-2
TOKEN-TYPE Statement 7-2
TOKEN-CODE Statement 7-8
TOKEN-MAP Statement 7-13
8. Dictionary Manipulation Statements
DELETE Statement 8-1
EXIT Statement 8-4
OUTPUT Statement 8-5
OUTPUT UPDATE Statement 8-8
SHOW USE OF Statement 8-11
9. DDL Compiler Commands
ANSICOBOL Command 9-6
C Command 9-7
C00CALIGN Command 9-11
CCHECK Command 9-11
CDEFINEUPPER Command 9-13

Contents
Data Definition Language (DDL) Reference Manual—426798-002
iv
9. DDL Compiler Commands
CFIELDALIGN_MATCHED2 Command 9-13
CIFDEF, CIFNDEF, and CENDIF Commands 9-17
CIFDEF Command 9-17
CIFNDEF Command 9-17
CENDIF Command 9-17
CIFDEF, CIFNDEF, CENDIF Command Guidelines 9-17
CIFDEF, CIFNDEF, CENDIF Command Example 9-18
CLISTIN Command 9-19
CLISTOUT Command 9-20
COBCHECK Command 9-22
COBLEVEL Command 9-24
COBOL Command 9-25
COLUMNS Command 9-27
COMMENTS Command 9-28
CPRAGMA Command 9-30
CTOKENMAP_ASDEFINE Command 9-31
CUNDEF Command 9-34
C_DECIMAL Command 9-35
C_MATCH_HISTORIC_TAL Command 9-38
DO_PTAL_ON Command 9-40
DDL Command 9-42
DEFLIST Command 9-44
DICT Command 9-47
DICTN Command 9-49
DICTR Command 9-51
EDIT Command 9-52
ERRORS Command 9-54
EXPANDC Command 9-56
FIELDALIGN_SHARED8 Command 9-58
FILLER Command 9-59
FORCHECK Command 9-62
FORTRAN Command 9-63
FORTRANUNDERSCORE Command 9-66
FUP Command 9-66
HELP Command 9-69
LINECOUNT Command 9-69
LIST Command 9-70
NCLCONSTANT Command 9-71
NEWFUP_FILEFORMAT Command 9-73

Contents
Data Definition Language (DDL) Reference Manual—426798-002
v
10. Dictionary Maintenance
NOFILEFORMAT Command 9-76
OLDFUP_FILEFORMAT Command 9-78
OUT Command 9-80
OUTPUT_SENSITIVE Command 9-81
PAGE Command 9-84
PASCAL Command 9-84
PASCALBOUND Command 9-87
PASCALCHECK Command 9-88
PASCALNAMEDVARIANT Command 9-90
REPORT Command 9-90
RESET Command 9-92
SAVE Command 9-93
SECTION Command 9-94
SETLOCALENAME Command 9-95
SETSECTION Command 9-96
SOURCE Command 9-98
SPACING Command 9-99
TACL Command 9-100
TACLGEN Command 9-103
TAL Command 9-103
TALALLOCATE Command 9-106
TALBOUND Command 9-107
TALCHECK Command 9-108
TALUNDERSCORE Command 9-110
TEDIT Command 9-110
TIMESTAMP Command 9-112
VALUES Command 9-113
WARN Command 9-115
WARNINGS Command 9-115
10. Dictionary Maintenance
Generating a Backup Schema 10-1
Adding New Dictionary Objects 10-2
Deleting Dictionary Objects 10-3
Deleting Unreferenced Objects 10-4
Deleting Referenced Objects 10-4
Modifying Dictionary Objects 10-7
Modifying Unreferenced Objects 10-8
Modifying Referenced Objects 10-9

Contents
Data Definition Language (DDL) Reference Manual—426798-002
vi
A. DDL Messages
Making Major Modifications 10-12
Changing Dictionary Security 10-14
Moving a Dictionary 10-14
Moving a Nonaudited Dictionary 10-15
Moving an Audited Dictionary 10-15
Purging a Dictionary 10-18
Increasing Dictionary File Size 10-19
Rebuilding a Dictionary 10-20
Rebuilding a Nonaudited Dictionary 10-20
Rebuilding an Audited Dictionary 10-21
Converting a Dictionary 10-21
A. DDL Messages
Warnings and Errors A-1
DDL Error and Warning Messages A-1
B. Sample Schemas
Sample Database Schema B-1
Host-Language Source Code B-1
Database Schema Listing B-2
Sample SPI Schema B-7
DDL Commands to Create an SPI Schema B-8
Selected ZSPIDDL Statements B-9
ASSNDDL Statements B-10
C. DDL Data Translation
D. Dictionary Database Structure
Dictionary Components D-1
Elements D-2
Text Items D-2
Dictionary Files D-3
Field Descriptions D-4
DICTCDF Fields D-5
DICTDDF Fields D-6
DICTKDF Fields D-7
DICTMAP Fields D-11
DICTOBL Fields D-12
DICTODF Fields D-28
DICTOTF Fields D-31

Contents
Data Definition Language (DDL) Reference Manual—426798-002
vii
E. Dictionary Reports
DICTOUF Fields D-33
DICTRDF Fields D-35
DICTTKN Fields D-41
DICTTYP Fields D-42
DICTVER Fields D-44
Definition and Record Storage in the Dictionary D-45
Dictionary Definition File D-45
Object Definition File D-46
Object Build List D-46
Object Text File D-47
Record Definition File D-47
Key Definition File D-48
Dictionary Structure Link Diagram D-48
E. Dictionary Reports
Using Enform Queries for Dictionary Reports E-1
Producing Dictionary Reports E-3
Compiling the DDL Dictionary Schema E-3
Requesting Reports E-4
F. Syntax Summary
DDL Run Command F-1
CONSTANT Statement F-1
DEFINITION Statement F-1
Field Definition F-1
Group Definition F-2
Reference Definition F-3
DELETE Statement F-3
EXIT Statement F-3
OUTPUT Statement F-4
OUTPUT UPDATE Statement F-4
RECORD Statement F-4
File-Creation Syntax F-5
Reference Record Structure Syntax F-5
Record Structure Syntax Summary F-6
Key Assignment Syntax F-6
SHOW USE OF Statement F-7
TOKEN-CODE Statement F-7
TOKEN-MAP Statement F-7
TOKEN-TYPE Statement F-8

Contents
Data Definition Language (DDL) Reference Manual—426798-002
viii
G. Pathmaker and DDL
DEFINITION and RECORD Statement Clauses F-8
AS Clause F-8
DISPLAY Clause F-8
EDIT-PIC Clause F-8
EXTERNAL Clause F-8
FILLER Clause F-8
HEADING Clause F-8
HELP Clause F-9
JUSTIFIED Clause F-9
KEYTAG Clause F-9
LN Clause F-9
MUST BE Clause F-9
NULL Clause F-9
OCCURS Clause F-9
OCCURS DEPENDING ON Clause F-10
PICTURE Clause F-10
REDEFINES Clause F-10
SPI-NULL Clause F-10
SQLNULLABLE Clause F-10
TACL Clause F-11
TYPE Clause F-11
UPSHIFT Clause F-12
USAGE Clause F-12
VALUE Clause F-12
66 RENAMES Clause F-12
88 Condition-Name Clause F-13
89 Enumeration Clause F-13
Compiler Commands F-14
G. Pathmaker and DDL
H. DDL Alignment Rules
C00CALIGN Alignment Rules H-1
NOC00CALIGN Alignment Rules H-2
C_MATCH_HISTORIC_TAL Alignment Rules H-3
FIELDALIGN_SHARED8 Alignment Rules H-3