7.8.3 Control statement (alter system statement)
This section explains the operands of the alter system statement. In the following table, each number corresponds to the number assigned to each operand.
No. | Operand |
---|
1 | alter system [dicinf {unlimited|limited}] |
2 | [dictionary datatype mchar use] |
-- | ; |
- Organization of this subsection
- (1) dicinf {unlimited|limited}
- (2) dictionary datatype mchar use
(1) dicinf {unlimited|limited}
Specifies whether or not to limit the information that can be retrieved by accessing data dictionary tables based on the user's privileges (specification of the reference privilege for data dictionary tables). For details about how to specify the reference privilege for data dictionary tables, see the HiRDB Version 9 System Operation Guide.
- unlimited
- All information can be retrieved when a data dictionary table is accessed.
- limited
- The information that can be retrieved when a data dictionary table is accessed is to be restricted based on the user's privileges (users with DBA privilege can retrieve all information; users without DBA privilege can retrieve only the information available to their assigned privilege).
- Rules
- If a view table has been defined that references a data dictionary table, or an SQL object routine has been defined, you cannot change the data dictionary table reference privileges.
- To modify the data dictionary table reference privileges, you need to delete all view tables that reference the data dictionary table beforehand.
- If an SQL object routine has been defined that references data dictionary tables, the system issues a warning message indicating that the SQL object will be disabled, then terminates the processing normally. In this case, you need to re-create the routine's disabled SQL object using ALTER PROCEDURE or ALTER ROUTINE. You can identify the disabled SQL object by searching the data dictionary table. For details about ALTER PROCEDURE or ALTER ROUTINE, see the HiRDB Version 9 SQL Reference. For details about how to search a data dictionary table, see the HiRDB Version 9 UAP Development Guide.
- When limited is specified, there is an increase in the number of UAP access tables used to retrieve data dictionary tables. Therefore, you must increase the number of concurrently accessible base tables (value of pd_max_access_tables in the system common definition). Five base tables must be accessible concurrently for each data dictionary table.
(2) dictionary datatype mchar use
Specifies that mixed-character data can be used in dictionary tables. When this operand is specified, the data type of dictionary table columns becomes MVARCHAR.
- Criteria
- If kanji characters are used in a table name or column names, the data type is changed to MVARCHAR.
- Rules
- If a view table is defined that references data dictionary tables, you cannot specify this operand. To specify this operand, you need to delete such view tables beforehand.
- If an SQL object routine has been defined that references data dictionary tables, the system issues a warning message indicating that the SQL object will be disabled, then terminates the processing normally. In this case, you need to re-create the routine's disabled SQL object using ALTER PROCEDURE or ALTER ROUTINE. You can identify the disabled SQL object by searching the data dictionary table. For details about ALTER PROCEDURE or ALTER ROUTINE, see the HiRDB Version 9 SQL Reference. For details about how to search a data dictionary table, see the HiRDB Version 9 UAP Development Guide.