Start of change

DNS_LOOKUP_IP scalar function

Edit online

The DNS_LOOKUP_IP scalar function returns a hostname for a specified IP address.

Authorization: None required.

Read syntax diagramSkip visual syntax diagramDNS_LOOKUP_IP( IP_ADDRESS => ip-address )

The schema is QSYS2.

ip-address
A character string containing the IP address to be resolved to a hostname. The IP address can be in either IPv4 or IPv6 format.

The result of the function is a varying length character string that contains the corresponding hostname. If a hostname cannot be determined, the null value is returned.

Example

  • Determine the hostname for IP address 129.42.38.10. The result is ibm.com.
    VALUES QSYS2.DNS_LOOKUP_IP('129.42.38.10');
End of change