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:

 
% setenv PDHOST=host1
% setenv PDNAMEPORT=20001
% setenv PDUSER='"k916321"/"k916321"'
        :
 

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

Note that the Linux client edition for AP 8000 does not support the database definition utility.

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

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