Chapter 2: Transact-SQL Functions

host_id

Description

Returns the client computer’s operating system process ID for the current Adaptive Server client.

Syntax

host_id()

Parameters

None.

Examples

Example 1

In this example, the name of the client computer is “ephemeris” and the process ID on the computer “ephemeris” for the Adaptive Server client process is 2309:

select host_name(), host_id()
----------------------------- -----------------------
 ephemeris                    2309

The following is the process information, gathered using the UNIX ps command, from the computer “ephemeris” showing that the client in this example is “isql” and its process ID is 2309:

2309 pts/2    S  0:00 /work/as125/OCS-12_5/bin/isql

Usage

host_id, a system function, returns the host process ID of the client process (not the server process).
For general information about system functions, see “String functions”.

Standards

ANSI SQL – Compliance level: Transact-SQL extension.

Permissions

Any user can execute host_id.