Dictionary Maintenance
Data Definition Language (DDL) Reference Manual — 426798-002
10- 7
Modifying Dictionary Objects
The following example of an interactive DDL session shows the DDL statements and
commands needed to delete AGE; it also shows the response of the DDL compiler to
each statement and command.
Modifying Dictionary Objects
Modifying an object stored in a dictionary is similar to deleting an object. If the object is
never referenced by other objects, the modification is comparatively simple. If the
44> DDL DICT $data.sales
Dictionary opened on subvol $DATA.SALES for update access
!?DDL delfile
Output source for DDL is opened on $DATA.SALES.DELFILE
!OUTPUT UPDATE age.
Searching for objects affected by AGE
Loading Definition AGE
DDL source output produced for AGE.
Loading Definition EMPLOY
DDL source output produced for EMPLOY.
Loading Record EMPLOYEE
DDL source output produced for EMPLOYEE.
!?NODDL
!?EDIT delfile; L 1/10
1 ?Section AGE-DELETES
2 Delete Record EMPLOYEE.
3 Delete Definition EMPLOY.
4
5 ?Section AGE
6 .
7 .
8 ?Section EMPLOY
9 .
10.
*EXIT
!?SOURCE delfile (age-deletes)
1 ?SECTION AGE-DELETES
2 Delete Record EMPLOYEE.
Record EMPLOYEE deleted from dictionary.
3 Delete Definition EMPLOY.
Definition EMPLOY deleted from dictionary.
4
!DELETE DEF age.
Definition AGE deleted from dictionary.
!EXIT
Objects:
Added Replaced
Deleted
Definitions
0
0
2
Records
0
0
1
Dictionary on subvol \SYS1.$DATA.SALES is closed.
Errors detected: 0
Warnings detected: 0
Run DDL and open
dictionary
Open new DDL source file
Write update statements
to DELFILE
Close DDL file DELFILE
List DELFILE
Get name of section with
DELETE statements
Section to define AGE followed by
sections to redefine objects that refer
to AGE
Submit section to DDL
DDL executes AGE-
DELETES
Delete AGE definition
Exit from DDL
VST1004.vsd
Содержание DDL D40
Страница 36: ...Introduction to DDL Data Definition Language DDL Reference Manual 426798 002 1 14 Examining a Dictionary ...
Страница 66: ...Named Constants Data Definition Language DDL Reference Manual 426798 002 4 10 Standard SPI Constants ...
Страница 230: ...Dictionary Manipulation Statements Data Definition Language DDL Reference Manual 426798 002 8 14 SHOW USE OF Statement ...
Страница 370: ...Dictionary Maintenance Data Definition Language DDL Reference Manual 426798 002 10 24 Converting a Dictionary ...
Страница 456: ...Sample Schemas Data Definition Language DDL Reference Manual 426798 002 B 12 ASSNDDL Statements ...
Страница 470: ...DDL Data Translation Data Definition Language DDL Reference Manual 426798 002 C 14 ...
Страница 528: ...Dictionary Reports Data Definition Language DDL Reference Manual 426798 002 E 8 Requesting Reports ...
Страница 552: ...DDL Alignment Rules Data Definition Language DDL Reference Manual 426798 002 H 4 FIELDALIGN_SHARED8 Alignment Rules ...
Страница 576: ...Index Data Definition Language DDL Reference Manual 426798 002 Index 22 Special Characters ...