Dictionary Maintenance
Data Definition Language (DDL) Reference Manual — 426798-002
10 -12
Making Major Modifications
Making Major Modifications
If you have made many changes to a dictionary interactively through the DDL compiler,
you probably should recompile the entire dictionary.
Rather than using the original schema, which might not reflect all changes to the
dictionary, you should create a new source schema from the dictionary. You can
47> DDL DICT $data.sales
Dictionary opened on subvol $DATA.SALES for update access
!?DDL modfile !
Output source for DDL is opened on $DATA.SALES.MODFILE
!OUTPUT UPDATE zip-cd.
Searching for objects affected by ZIP-CD
Loading Definition ZIP-CD
DDL source output produced for ZIP-CD.
Loading Definition ADDR
DDL source output produced for ADDR.
Loading Definition CUSTINFO
DDL source output produced for CUSTINFO.
Loading Definition SUPPINFO
DDL source output produced for SUPPINFO.
Loading Record CUSTOMER
DDL source output produced for CUSTOMER.
Loading Record SUPPLIER
DDL source output produced for SUPPLIER.
!?NODDL
!?EDIT modfile;xvs f
?Section ZIP-CD-DELETES
Delete Record SUPPLIER.
.
.
.
Delete Definition ADDR.
?Section ZIP-CD
Definition ZIP-CD Pic "9(5)".
?Section ADDR
Definition ADDR.
•
•
•
?Section SUPPLIER
Record SUPPLIER.
•
•
•
End
*EXIT
!?SOURCE modfile
!EXIT
Run DDL and open dictionary
Open and clear DDL source
MODFILE
Write update statements
to MODFILE
Close DDL source file
Edit MODFILE
Statements to delete
referring objects
Definition to be modified
Change to 9(9)
Statements to redefine deleted objects
Exit from editor
Compile changes into dictionary and
exit from DDL
VST1007.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 ...