3.3.1 define system statement

This section explains the define system statement's operands. Each number in the table as follows corresponds to each operand.

No.Operand
1

define system [dicinf {unlimited | limited}]

2

             [dictionary datatype mchar {use | nouse}]

--

 ;

Organization of this subsection
(1) dicinf {unlimited|limited}
(2) dictionary datatype mchar {use|nouse}

(1) dicinf {unlimited|limited}

Specifies whether or not information retrieved when data dictionary tables are accessed is to be restricted on the basis of user's privileges:

unlimited
All information can be retrieved when a data dictionary table is accessed
limited
The information to be retrieved when a data dictionary table is accessed is to be restricted on the basis of the user's privileges (a user with DBA privilege can retrieve all information; a user without DBA privilege can retrieve only the information authorized for his or her privileges)

When limited is specified, the number of UAP access tables for making retrievals from dictionary tables increases. Therefore, the number of simultaneously accessible base tables (the value of pd_max_access_tables) should be increased. Five base tables should be accessible simultaneously for each data dictionary table.

For details about how to set data dictionary table referencing privileges, see the HiRDB Version 9 System Operation Guide.

(2) dictionary datatype mchar {use|nouse}

Specifies whether or not mixed-character data can be used in the data of the dictionary tables:

use
Data type for dictionary table columns is to be MVARCHAR
nouse
Data type for dictionary table columns is to be VARCHAR

Following are guidelines for selecting MVARCHAR or VARCHAR: