7.8.2 Example

This section presents an example of using the database structure modification utility (modifying data dictionary table attribute definitions).

Organization of this subsection
(1) Modifying data dictionary table attribute definitions

(1) Modifying data dictionary table attribute definitions

When data dictionary tables are accessed, this example limits the information available to users according to users' privileges. It allows mixed character string data in the data dictionary table. This example assumes that a HiRDB single server configuration is used.

Command to be executed

pdmod -a /usr/seifile/mofl01

Contents of the control statement file (/usr/seifile/mofl01)

/* Modifying data dictionary table attribute definitions */
alter system dicinf limited   ......................1
        dictionary datatype mchar use ;   ..........2

Explanation
  1. When data dictionary tables are accessed, this statement limits the information available to users as appropriate to the users' privileges.
  2. This operand enables mixed character string data to be used in the data dictionary.