This section explains the define system statement's operands. Each number in the table as follows corresponds to each operand.
No. | Operand |
---|---|
define system [dicinf {unlimited | limited}] | |
[dictionary datatype mchar {use | nouse}] | |
- | ; |
Specifies whether or not information retrieved when data dictionary tables are accessed is to be restricted on the basis of user's 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 8 System Operation Guide.
Specifies whether or not mixed-character data can be used in the data of the dictionary tables:
Following are guidelines for selecting MVARCHAR or VARCHAR: