Creates a new node within a network. The name of the new node must differ from all existing nodes in the network. Note that it is only possible to create an instance node on a server that has already been provisioned with the Edge Intelligence product.
Available in the network database and requires the star$network role.
Parameters:
| Name | Optional | Type | Description |
| node$ | Mandatory | Text | The name of the node to be created. |
| description$ | Optional | Text | A description of the node. |
| type$ | Mandatory | Char | The type of node (A,E,I) |
| host$ | Optional | Text | Server name or IP address for an instance node |
| address$ | Optional | Text | Optional address information for an instance |
| location$ | Optional | Text | Optional geographical location information |
| location$ | Optional | Numeric | Optional latitude of the node |
| latitude$ | Optional | Numeric | Optional longitude of the node |
Examples:
SELECT create_node('mynode','my node','A',null,null,null,null,null); -- creates an area node.
SELECT create_node('mynode','my node','E',null,null,null,null,null); -- creates an edge node.
SELECT create_node('mynode','my node','I','host',null,null,null,null); -- creates an instance node.
Tips:
- Use a null value to omit an optional value.
- The star$nodes view indicates which nodes already exist.
Comments
Article is closed for comments.