602SQL Documentation Index  

_IV_IP_ADDRESSES System Query

The system query _iv_IP_addresses returns a list of 602SQL Server addresses. The local loopback address (127.0.0.1) will not be returned.

Each IP address is returned in binary form and as a character string in dot notation.

Column description

Column type Type Contents
IP_string CHAR(17) IP address in readable form
IP_bin BINARY(6) IP address with appended zeros