4. Maintaining a Distributed Database : Register as Link Statement—Define Database Objects to Ingres Star : Register Procedure as Link Statement—Define Procedure to Ingres Star
 
Share this page                  
Register Procedure as Link Statement—Define Procedure to Ingres Star
The register procedure as link statement defines an already existing local DBMS database procedure to Ingres Star. No new database procedure is created.
The register procedure as link statement has the following format:
register procedure procedure_name
         as link
         [from [local_owner_name.]local_procedure_name]
         [with
                  [node = node_name,
                  database = database_name]
                  [, dbms = server_class]]
procedure
Identifies the object type
procedure_name
The Ingres Star name of the local DBMS database procedure 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.
local_procedure_name
The name of the database procedure 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 procedure_name you specify as the name of the local DBMS database procedure that you are registering.
Enter this name if you are registering the database procedure in your distributed database with a name different from its name in the local DBMS or if the name in the local DBMS does not follow naming conventions, is case sensitive, or is owned by another user.
The elements that are common to all three register as link statements are described in Register as Link Statement (see page Register as Link Statement—Define Database Objects to Ingres Star).