Data Definition Language (DDL) Reference Manual

Dictionary-Manipulation Statements
Data Definition Language (DDL) Reference Manual—529431-004
8-3
DELETE
Example 8-2 on page 8-3 deletes a definition called zip-cd that is referenced by two
other definitions (addr and custinfo), one of which (addr) is referenced by two
records (customer and supplier).
You can enter this code interactively (as in Example 8-2 on page 8-3) or you can place
the code in a file and use the SOURCE command to pass the code to the DDL
compiler, as in Example 8-3 on page 8-3.
To delete an SPI token type that is referenced by SPI token codes, first delete the
token codes, as in Example 8-4
on page 8-3.
Example 8-1. Deleting a Record Interactively
03> VOLUME $data.sales
Go to subvolume with dictionary.
04> DDL
Run DDL compiler.
!?DICT
Open dictionary.
!DELETE RECORD employee.
Delete record.
Example 8-2. Deleting a Record Interactively
!?DICT $data.sales
Open dictionary in its subvolume.
!DELETE RECORD customer supplier.
Delete records that refer to addr.
!DELETE DEF addr custinfo.
Delete definitions that refer to zip-cd.
!DELETE DEF zip-cd.
Delete zip-cd.
Example 8-3. Deleting a Record Interactively
05> DDL
!?SOURCE del-file
DICT command and DELETE statements are in del-file
!EXIT
Example 8-4. Deleting an SPI Token Type That SPI Token Codes References
06> VOLUME $spi.tokens
07> DDL DICT
!DELETE TOKEN-CODE assn-tkn-my-status, assn-tkn-stat-reply.
!DELETE TOKEN-TYPE assn-typ-status.
!EXIT