The ULTIM Dictionary
Another ULTIM
important characteristic is its integrated dictionary which eliminates
any redundancy pertaining to the definition of files and the fields
composing their records. The dictionary is a central catalogue in which
various data definitions (files, fields, procedures, translation
tables, etc.) are stored. Once these definitions are included in the
dictionary, they need not be re-coded in the programs since they are
invoked automatically by the system whenever they are needed.
Here are the main advantages offered by the ULTIM dictionary:
- All frequently-used files, databases and translation tables are defined centrally only once.
- Fields
are defined with descriptive names of up to 30 characters and default
printing formats; the fields may be automatically transformed by
functions.
- Existing COBOL-language field definitions, as well as original definitions found in most database dictionaries, can be used as is.
- Often-used blocks of ULTIM statements can be catalogued in the form of procedures
with parameter substitution capabilities.
- Options can be specified to tailor the system to specific needs or change default values.
Here is an example of dictionary
./ OPTIONS SPACING=AUTO, HEADING=AUTO ** EMPLOYEES FILE (VSAM TYPE) ./ FILE EMPLOYEE, EMPLOYEE,VK,175,EM-NUMERO EM-NUMBER ( 1,A,7) EM-NAME ( 8,A,30) EM-ADDRESS (38,A,30) EM-DEPARTMENT (68,A,3) EM-HIRING-DATE(80,N,8) EM-SALARY (88,N,8)
** PAYROLL FILE (ORACLE DATABASE) ./ FILE PAYROLL,SDEV,ORACLE, ./- (SELECT MATR NUMBER, NAME, SALARY FROM EMPL)
** DEPARTMENT CODES ./ TABLE DEPART, (1,3), (5,15) 001 ACCOUNTING 002 MARKETING 003 PERSONNEL 004 DATA PROCESSING
|