Data Definition Language (DDL) Reference Manual

1 data Definition Language (DDL) Reference ManualAbstractThis publication describes the DDL Language syntax and the DDL dictionary database. The audience includes application programmers and database VersionDDL D40 DDL H01 Supported Release Version Updates (RVUs)This publication supports and all subsequent J-series RVUs, and all subsequent H-series RVUs, and and all subsequent G-series RVUs, until otherwise indicated by its replacement NumberPublished529431-003 May 2010 Document History Part NumberProduct VersionPublished529431-002 DDL D40, DDL H01 July 2005529431-003 DDL D40, DDL H01 May 2010 Legal Notices Copyright 2010 Hewlett-Packard Development Company Confidential computer software. Valid license from HP required for possession, use or copying. Consistent with FAR and , Commercial Computer Software, Computer Software Documentation, and Technical data for Commercial Items are licensed to the Government under vendor's standard commercial information contained herein is subject to change without notice.

2 The only warranties for HP products and services are set forth in the express warranty statements accompanying such products and services. Nothing herein should be construed as constituting an additional warranty. HP shall not be liable for technical or editorial errors or omissions contained of the information contained in this publication may require authorization from the Department of , Windows, and Windows NT are registered trademarks of Microsoft Corporation. Intel, Itanium, Pentium, and Celeron are trademarks or registered trademarks of Intel Corporation or its subsidiaries in the United States and other countries. Java is a trademark of Sun Microsystems, , OSF/1, UNIX, X/Open, and the "X" device are registered trademarks and IT DialTone and The Open Group are trademarks of The Open Group in the and other countries. Open Software Foundation, OSF, the OSF logo, OSF/1, OSF/Motif, and Motif are trademarks of the Open Software Foundation, Inc.

3 OSF MAKES NO WARRANTY OF ANY KIND WITH REGARD TO THE OSF MATERIAL PROVIDED HEREIN, INCLUDING, BUT NOT LIMITED TO, THE IMPLIED WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR shall not be liable for errors contained herein or for incidental consequential damages in connection with the furnishing, performance, or use of this material. 1990, 1991, 1992, 1993 Open Software Foundation, Inc. This documentation and the software to which it relates are derived in part from materials supplied by the following: 1987, 1988, 1989 Carnegie-Mellon University. 1989, 1990, 1991 Digital Equipment Corporation. 1985, 1988, 1989, 1990 Encore Computer Corporation. 1988 Free Software Foundation, Inc. 1987, 1988, 1989, 1990, 1991 Hewlett-Packard Company. 1985, 1987, 1988, 1989, 1990, 1991, 1992 International Business Machines Corporation. 1988, 1989 Massachusetts Institute of Technology.

4 1988, 1989, 1990 Mentat Inc. 1988 Microsoft Corporation. 1987, 1988, 1989, 1990, 1991, 1992 SecureWare, Inc. 1990, 1991 Siemens Nixdorf Informationssysteme AG. 1986, 1989, 1996, 1997 Sun Microsystems, Inc. 1989, 1990, 1991 Transarc Corporation. This software and documentation are based in part on the Fourth Berkeley Software Distribution under license from The Regents of the University of California. OSF acknowledges the following individuals and institutions for their role in its development: Kenneth Arnold, Gregory S. Couch, Conrad C. Huang, Ed James, Symmetric Computer Systems, Robert Elz. 1980, 1981, 1982, 1983, 1985, 1986, 1987, 1988, 1989 Regents of the University of in the US Hewlett-Packard Company 529431-003iData Definition Language (DDL) Reference ManualGlossaryIndexExamplesFiguresTables Legal NoticesWhat s New in This ManualxixManual InformationxixNew and Changed InformationxixAbout This ManualxxiAudiencexxiiPrerequisite ManualsxxiiRelated ManualsxxiiiNotation Conventionsxxiii1.

5 Introduction to DDLC ompiling and Translating data Definitions1-3 Using DDL Definitions1-4 Creating a Dictionary1-5 Creating a Database1-7 Generating Source Code1-9 Maintaining a Dictionary1-12 Examining a Dictionary1-142. DDL Language ElementsNames2-1 Syntax2-2 Restrictions2-2 File Names2-3 Local File Names2-3 Network File Names2-4 Locale Names2-4 Numbers2-5 Strings2-5 National Literals2-6 Keywords2-6 ContentsData Definition Language (DDL) Reference Manual 529431-003ii2. DDL Language Elements (continued)2. DDL Language Elements(continued)Reserved Words2-11 Special Characters2-12 Comments2-12 Dictionary Comments2-13 Compiler Listing Comments2-15 Statements2-16 Commands2-183. Running the DDL CompilerRUN DDL Command3-1 Running the DDL Compiler Noninteractively3-3 Running the DDL Compiler Interactively3-4 Completion Codes3-54. Named ConstantsCONSTANT4-1 Numeric Constants4-3 Product Version Constants4-4 Existing Constants4-5C4-5 COBOL4-6 Pascal (D-series Systems Only)4-6 TAC L4-7 TAL4-8 Examples4-8 Standard SPI Constants4-95.

6 Definitions and RecordsDEFINITION5-1 Order of Clauses5-2 Definition Length5-2 Field Definition5-4 Group Definition5-5 Reference Definition5-7 Error Handling5-8 RECORD5-8 File-Creation Syntax5-10 Creation-Attribute Syntax5-12 Record Structure Syntax5-15 ContentsData Definition Language (DDL) Reference Manual 529431-003iii5. Definitions and Records (continued)5. Definitions and Records(continued)Record Reference Syntax5-16 Key Assignment Syntax5-17 Error Handling5-18 Examples5-19 Syntax Elements5-21 Clauses5-21 Other Elements5-236. Definition AttributesAS6-3 DISPLAY6-4 EDIT-PIC6-5 EXTERNAL6-6 FILLER6-7 HEADING6-9 HELP6-10 JUSTIFIED6-11 KEYTAG6-12LN6-13 MUST BE6-15 NULL6-19 OCCURS6-20 OCCURS DEPENDING ON6-23 PICTURE6-25 National data Items6-28C6-28 COBOL6-29 FORTRAN6-30 Pascal (D-series Systems Only)6-30pTAL and TAL6-30 TAC L6-31 REDEFINES6-31C6-32 COBOL6-33 FORTRAN6-33 Pascal (D-series Systems Only)6-34pTAL or TAL6-35 TAC L6-36 ContentsData Definition Language (DDL) Reference Manual 529431-003iv6.

7 Definition Attributes (continued)6. Definition Attributes(continued)SPI-NULL6-37 SQLNULLABLE6-39 TACL6-44 TYPE6-48 Specifying TYPE data -type6-51 Specifying TYPE def-name6-66 Specifying TYPE *6-67 UPSHIFT6-69 USAGE6-70VA L U E6-7566 RENAMES6-7988 Condition-Name6-8189 Enumeration6-847. SPI TokensDefining SPI Tokens7-2 TOKEN-TYPE7-2 TOKEN-TYPE Statement Output7-5 Standard SPI TOKEN-TYPE Definitions7-5 TOKEN-CODE7-8 TOKEN-CODE Statement Output7-10 Standard SPI TOKEN-CODE Definitions7-10 TOKEN-MAP7-13 Product Versions for Bit Fields7-17 TOKEN-MAP Statement Output7-18 Standard SPI Definitions in Token-Map Definitions7-198. Dictionary-Manipulation StatementsDELETE8-1 EXIT8-4 OUTPUT8-5 OUTPUT UPDATE8-7 SHOW USE OF8-119. DDL Compiler CommandsANSICOBOL9-7C9-8 ContentsData Definition Language (DDL) Reference Manual 529431-003v9. DDL Compiler Commands (continued)9.

8 DDL Compiler Commands(continued)C00 CALIGN9-12 CCHECK9-12 CDEFINEUPPER9-14 CFIELDALIGN_MATCHED29-14 CIFDEF, CIFNDEF, and CENDIF9-18 CLISTIN9-20 CLISTOUT9-21 COBCHECK9-23 COBLEVEL9-25 COBOL9-26 COLUMNS9-29 COMMENTS9-29 CPRAGMA9-32 CTOKENMAP_ASDEFINE9-32 CUNDEF9-36C_DECIMAL9-37C_MATCH_HISTORIC_ TAL9-40 DDL9-42 DEFLIST9-45 DICT9-47 DICTN9-49 DICTR9-51DO_PTAL_ON9-52 EDIT9-53 ERRORS9-55 EXPANDC9-56 FIELDALIGN_SHARED89-58 FILLER9-59 FORCHECK9-62 FORTRAN9-63 FORTRANUNDERSCORE9-66 FUP9-67 HELP9-70 LINECOUNT9-70 LIST9-71 NCLCONSTANT9-72 NEWFUP_FILEFORMAT9-75 NOFILEFORMAT9-77 ContentsData Definition Language (DDL) Reference Manual 529431-003vi9. DDL Compiler Commands (continued)9. DDL Compiler Commands(continued)OLDFUP_FILEFORMAT9-79 OUT9-82 OUTPUT_SENSITIVE9-83PA G E9-86 PASCAL (D-Series Systems Only)9-86 PASCALBOUND (D-Series Systems Only)9-89 PASCALCHECK (D-Series Systems Only)9-90 PASCALNAMEDVARIANT (D-Series Only)9-91 REPORT9-92 RESET9-94 SAVE9-94 SECTION9-96 SETLOCALENAME9-97 SETSECTION9-98 SOURCE9-99 SPACING9-101 TACL9-101 TACLGEN9-104 TAL9-105 TALALLOCATE9-108 TALBOUND9-109 TALCHECK9-110 TALUNDERSCORE9-111 TEDIT9-112 TIMESTAMP9-113VA L U ES9-115 WARN9-116 WARNINGS9-11610.

9 Dictionary MaintenanceGenerating a schema From a Dictionary10-1 Adding Dictionary Objects10-2 Deleting Dictionary Objects10-4 Deleting Unreferenced Objects10-4 Deleting Referenced Objects10-5 Modifying Dictionary Objects10-8 Modifying Unreferenced Objects10-9 Modifying Referenced Objects10-10 ContentsData Definition Language (DDL) Reference Manual 529431-003vii10. Dictionary Maintenance (continued)10. Dictionary Maintenance(continued)Making Major Modifications10-13 Changing Dictionary Security10-14 Moving a Dictionary10-14 Moving a Nonaudited Dictionary10-15 Moving an Audited Dictionary10-16 Purging a Dictionary10-18 Increasing Dictionary File Size10-19 Rebuilding a Dictionary10-20 Rebuilding a Nonaudited Dictionary10-20 Rebuilding an Audited Dictionary10-21 Converting a Dictionary10-22A. DDL MessagesB. Sample SchemasSample Database SchemaB-1 Host- Language Source CodeB-1 Database Schema ListingB-2 Sample SPI SchemaB-6 DDL Commands to Create an SPI SchemaB-8 Selected ZSPIDDL StatementsB-8 ASSNDDL StatementsB-10C.

10 DDL data TranslationD. Dictionary Database StructureDictionary ComponentsD-1 ObjectsD-1 ElementsD-2 Text ItemsD-2 Dictionary FilesD-3 DICTALT (Alternate Key File)D-4 DICTCDF (Constant Definition File)D-4 DICTDDF (Dictionary Definition File)D-6 DICTKDF (Key Definition File)D-8 DICTMAP (Token Map File)D-13 DICTOBL (Object Build List)D-15 DICTODF (Object Definition File)D-37 DICTOTF (Object Text File)D-41 ContentsData Definition Language (DDL) Reference Manual 529431-003viiiD. Dictionary Database Structure (continued)D. Dictionary Database Structure(continued)DICTOUF (Object Usage File)D-45 DICTOUK (Object Usage Key File)D-47 DICTRDF (Record Definition File)D-47 DICTTKN (Token Code File)D-56 DICTTYP (Token Type File)D-58 DICTVER (Token Map Field Version File)D-61 Definition and Record Storage in the DictionaryD-63 DICTDDF (Dictionary Definition File)D-64 DICTODF (Object Definition File)D-64 DICTOBL (Object Build List)D-65 DICTOTF (Object Text File)D-65 DICTRDF (Record Definition File)D-66 DICTKDF (Key Definition File)D-67 Dictionary Structure Link DiagramD-68E.