Register View as Link Statement--Define View to Ingres Star
The register view as link statement defines an already existing local DBMS view to Ingres Star. No new view is created.
The register view as link statement has the following format:
register [view] view_name
[(col_name {, col_name})]
as link
[from [local_owner_name.]local_view_name]
[with
[node =node_name,
database =database_name]
[, dbms = server_class]]
view
An optional object identifier. Whether or not you specify view, Ingres Star queries the local DBMS and determines the object type.
If you specify view, Ingres Star issues an error if the local DBMS type is not a view.
view_name
The Ingres Star name of the local DBMS view you are registering.
It can be delimited with double quotes to preserve case and allow special characters. However, if the Ingres Star database does not support mixed-case delimited identifiers and the local DBMS or Enterprise Access product does support mixed-case delimited identifiers, you should use a single-quote delimiter in order for Ingres Star to preserve the case.
This name must follow Ingres view naming conventions. It will appear in the Ingres Star catalogs as a view. In the table_subtype column of the iitables standard system catalog, the Ingres Star view name will have a table_subtype of L (registered as Link). (For more information on catalogs, see the chapter "Understanding Ingres Star Catalogs.")
local_view_ name
The name of the view in the local DBMS.
It can be delimited with double quotes to preserve case and allow special characters. However, if the Ingres Star database does not support mixed-case delimited identifiers and the local DBMS or Enterprise Access product does support mixed-case delimited identifiers, you should use a single-quote delimiter in order for Ingres Star to preserve the case.
The default is to use the distributed database view_name you specify as the name of the local DBMS view that you are registering.
Enter this name if you are registering the view in your distributed database with a name different from its name in the local DBMS or if the view name in the local DBMS does not follow Ingres naming conventions and/or is case sensitive or is owned by another user.
Note: This name must be the actual base name, not a synonym.
The elements that are common to all three register as link statements are described in
Register as Link Statement--Define Database Objects to Ingres Star.
Example: Register View as Link
This statement registers the view follow_ups from the database west_usa on the node reno, and gives it the name usa_visits:
register view usa_visits as link
from follow_ups
with node = reno, database = west_usa;
Last modified date: 11/09/2022