Data Definition Language (DDL) Reference Manual

Sample Schemas
Data Definition Language (DDL) Reference Manual—529431-004
B-2
Database Schema Listing
For FORTRAN, the DDL compiler issues warning messages for all constants;
constants are not supported by FORTRAN. The constants that describe display,
heading, and help values are not used by the source code, so this causes no
problems; the generated source code will execute successfully.
Database Schema Listing
Figure B-1. Database Schema Listing (page1of5)
!***************************************************************
! COMPILER COMMANDS:
!***************************************************************
? ERRORS 1
? DICT !
? COMMENTS
? FUP FUPSRC !
? COBOL COBSRC85 !
!***************************************************************
! CONSTANT DEFINITIONS
!***************************************************************
CONSTANT custnum-heading VALUE "Customer/Number"LN en_US.ISO8859-1,
"Cliente/Numero"LN.es_ES.ISO8859-1
"Client/Numero"LN fr_FR.ISO8859-1.
CONSTANT suppnum-heading VALUE "Supplier/Number"LN en_US.ISO8859-1,
"Proveedor/Numero",LN.es_ES.ISO8859-1
"Fournisseur/Numero"LN fr_FR.ISO8859-1.
CONSTANT partnum-heading VALUE "Part/Number"LN en_US.ISO8859-1,
"Repuesto/Numero"LN.es_ES.ISO8859-1,
"Piece/Numero"LN fr_FR.ISO8859-1.
CONSTANT ordernum-heading VALUE "Order/Number"LN en_US.ISO8859-1,
"Orden/Numero",LN.es_ES.ISO8859-1
"Commande/Numero"LN fr_FR.ISO8859-1.
CONSTANT empnum-heading VALUE "Employee/Number"LN en_US.ISO8859-1
"Empleado/Numero"LN.es_ES.ISO8859-1,
"Employe/Numero"LN fr_FR.ISO8859-1.
CONSTANT regnum-heading VALUE "Region/Number"LN en_US.ISO8859-1,
"Region/Numero"LN.es_ES.ISO8859-1,
"Region/Numero"LN fr_FR.ISO8859-1.
CONSTANT branchnum-heading VALUE "Branch/Number"LN en_US.ISO8859-1,
"Sucursal/Numero"LN.es_ES.ISO8859-1,
"Bureau/Numero"LN fr_FR.ISO8859-1.
CONSTANT manager-heading VALUE "Manager"LN en_US.ISO8859-1,
"Gerente",LN.es_ES.ISO8859-1
"Chef De Service"LN fr_FR.ISO8859-1.
CONSTANT salesperson-heading VALUE "Salesperson"LN en_US.ISO8859-1,
"Vendedor"LN.es_ES.ISO8859-1,
"Vendeur"LN fr_FR.ISO8859-1.
CONSTANT mdy-date-display VALUE "M<99/99/99>".
CONSTANT part-cost-display VALUE "M<ZZZ,ZZ9,99>".