HP DDL D40 Bedienungsanleitung

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

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

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

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

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

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

Inhaltsverzeichnis

Andere HP Software Handbücher

HP AA-RTDRB-TE Bedienungsanleitung

HP TACL Betriebsanleitung

HP StorageWorks MSA 2/8 - SAN Switch Bedienungsanleitung

HP C7791C - DesignJet 130 Color Inkjet Printer Konfigurationshandbuch

HP StorageWorks 4/8 - SAN Switch Bedienungsanleitung

HP 201723-B21 - HP StorageWorks Modular SAN Array 1000 Hard... Bedienungsanleitung

HP Data Protector A.06.11 Kurzanleitung zur Einrichtung

HP Neoware c50 - Thin Client Bedienungsanleitung

HP T5145 - Thin Client - Tower Service-Handbuch

HP JetCAPS Bedienungsanleitung

HP Compaq Elite 8200 AIO Bedienungsanleitung

HP T5145 - Thin Client - Tower Bedienungsanleitung

HP BAAD0010HBK-NHSN Bedienungsanleitung

HP BladeSystem bc2000 - Blade PC Bedienungsanleitung

HP BladeSystem Dual NC370i - Multifunction Network... Bedienungsanleitung

HP AB500A - Integrated Lights-Out Advanced Bedienungsanleitung

HP BL680c - ProLiant - G5 Bedienungsanleitung

HP ProLiant xw25p Bedienungsanleitung

HP C7791C - DesignJet 130 Color Inkjet Printer Konfigurationshandbuch

HP HP 2605dn Print Drivers Service-Handbuch

HP Rx2620-2 - Integrity - 0 MB RAM Bedienungsanleitung

HP Data Protector A.06.11 Bedienungsanleitung

HP D6030A - NetServer - E50 Bedienungsanleitung

HP Data Protector A.06.11 Bedienungsanleitung

Beliebte Software Handbücher anderer Marken

COMPRO

COMPRO COMPROFM Bedienungsanleitung

Muratec

Muratec OFFICEBRIDGE ONLINE Bedienungsanleitung

Oracle

Oracle Contact Center Anywhere 8.1 Bedienungsanleitung

Adobe

Adobe 65007312 - Photoshop Lightroom Handbuch

Avaya

Avaya NULL One-X for RIM Blackberry Bedienungsanleitung

PS Audio

PS Audio PowerPlay Betriebsanleitung

Brady

Brady LOCKOUT PRO 3.0 Service-Handbuch

Avaya

Avaya Interaction Center Bedienungsanleitung

Texas Instruments

Texas Instruments TI-83 Plus Silver Edition Handbuch

Novell

Novell GROUPWISE 8 - INTERNET AGENT Bedienungsanleitung

Oracle

Oracle Application 9i Bedienungsanleitung

Acer

Acer RDM Bedienungsanleitung

Canon

Canon Vixia HF21 Bedienungsanleitung

Canon

Canon ZR950 Bedienungsanleitung

Samsung

Samsung Auto Backup Bedienungsanleitung

Polycom

Polycom Vortex EF2201 Montage- und Bedienungsanleitung

Brocade Communications Systems

Brocade Communications Systems Brocade 8/12c Bedienungsanleitung

Novell

Novell SP2 - S Bedienungsanleitung