B.12 Content of SQL_DEFINE_ENVIRONMENT

SQL_DEFINE_ENVIRONMENT stores the environment information that was in effect when making or changing a view definition. Each row stores the environment information of one viewed table.

The following table describes the content of SQL_DEFINE_ENVIRONMENT.

Table B‒14: Content of SQL_DEFINE_ENVIRONMENT
No.	Column name	Data type	Stored information
1	`RESOURCE_TYPE`	`CHAR(1)`	Definition information type: `'V'`: Viewed table
2	`RESOURCE_ID`	`SMALLINT`	Definition information ID `View ID`
3	`DELETE_RESERVED_WORD`	`VARCHAR(32000)`	Reserved words that had been unregistered when the `CREATE` `VIEW` statement was executed^#. If no reserved words were unregistered, the null value is stored.
4	`DEFINE_VR`	`CHAR(8)`	Version that was in effect during definition Stored in the following format: `'VV-RR'` `VV`: Version number `RR`: Revision number
5	`RECREATE_VR`	`CHAR(8)`	The version of the HADB server when the `ALTER VIEW` statement was executed Version information for the HADB server that was in effect when an `ALTER VIEW` statement was executed most recently for the viewed table is stored in the following format: `'VV-RR'` `VV`: Version number `RR`: Revision number The null value is stored if no `ALTER VIEW` statements have been executed for the viewed table.

#

The DELETE_RESERVED_WORD column stores the reserved words to be unregistered as defined in the reserved word unregistration function environment in the order they were specified in the server definition, delimited by the comma (,) and without spaces.

The following is a storage example in which the reserved words ACTION and CATALOG are specified in the reserved word unregistration function environment to be unregistered and in which two viewed tables are defined.

Example: Search of SQL_DEFINE_ENVIRONMENT

SELECT * FROM "MASTER"."SQL_DEFINE_ENVIRONMENT"

Search result

[Figure]

To Page Top