Dictionary Maintenance
Data Definition Language (DDL) Reference Manual — 426798-002
10- 9
Modifying Referenced Objects
the record definition, and then compile the record definition back into the dictionary
with a SOURCE command; for example:
Alternatively, assume that ORDERDATE is not defined in ORDERINFO. In this case,
you should write the definition of ORDERINFO together with all the definitions and
records that refer to it to the DDL source file. For example:
Modifying Referenced Objects
Constants, definitions, and SPI token maps can be referenced by other objects. You
can use the SHOW USE OF command to determine whether the object you want to
modify is referenced by any other objects.
45> DDL DICT $data.sales
!?DDL newsrc !
!OUTPUT RECORD orders.
Loading Record ORDERS
DDL source output produced for ORDERS
!?NODDL
!?EDIT newsrc;LA
3 ?Section ORDERS
6 Record ORDERS.
7 File is "$data.sales.orders" Key-sequenced
8
Audit.
9 Definition is ORDERINFO.
10
11 Key is ORDERNUM Duplicates not allowed.
12 Key "sn" is SALESPERSON.
13 Key "cn" is CUSTNUM.
14 End
*A 13
13 Key "cn" is CUSTNUM.
13.1 KEY "od" IS orderdate
13.2 //
*EXIT
!?SOURCE newsrc
!EXIT
Run DDL and open dictionary
Open and clear source file
Write record definition to
source file
Close source file
List and edit record
ORDERS
Add new alternate key
Compile modified record
VST1005.vsd
46> DDL DICT
!?DDL newsrc !
!OUTPUT UPDATE orderinfo.
!?NODDL, EDIT newsrc
.
.
.
*EXIT
!?SOURCE newsrc
ORDER-REC is included
in NEWSRC
Add ORDERDATE to ORDERINFO and add
key field to ORDER-REC
VST1006.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 ...