4.1.1 Function

The database definition utility (pddef) defines schemas and modifies existing schema definitions.

This utility executes a definition SQL entered from the standard input, defines or changes schema information, then outputs the execution result to the standard output. The definition information is stored in data dictionary tables.

Before executing the database definition utility, you need to specify the client environment definitions. Specify at least PDHOST, PDNAMEPORT, and PDUSER. The following shows an example:

PDHOST=host1
PDNAMEPORT=20001
PDUSER=\""k916321"\"/\""k916321"\"
       :

For details about the client environment definitions, see the HiRDB Version 9 UAP Development Guide.

The figure below provides an overview of the database definition utility (pddef).

Figure 4-1 Overview of database definition utility (pddef)

[Figure]