ttHostNameGet

This procedure returns the name of the current local host for the database. The value returned is only for the current session. It is not a systemwide setting and does not persist after the current session has been disconnected.

Use this procedure to check whether a particular store name in a scheme refers to the current host. This can be helpful when configuring replication schemes.

Required Privilege

This procedure requires no privilege.

Usage in TimesTen Scaleout and TimesTen Classic

This procedure is supported in TimesTen Classic.

TimesTen Scaleout applications can call this built-in procedure.

This procedure returns a row for the element from which it was called.

Related Views

This procedure has these related views.

SYS.GV$HOST_NAME

SYS.V$HOST_NAME

Syntax

ttHostnameGet()

Parameters

ttHostNameGet has no parameters.

Result Set

ttHostNameGet returns the result:

Column	Type	Description
`hostName`	`TT_VARCHAR (200)`	The current default local host setting for the database. If a default has not been supplied then the current host name is returned.

Examples

CALL ttHostNameGet ();
< myhost >
1 row found.