Lookup IP address host using SQL Simon Hutchinson

Added as part of the recent Technology Refreshes, IBM i 7.5 TR2 and 7.4 TR8, is a new scalar function that returns the hostname for an IP address.
The syntax for this scalar function, DNS_LOOKUP_IP, is simple, and can be used in one of two ways:

01 VALUES DNS_LOOKUP_IP(IP_ADDRESS => ‘123.456.789.12’) ;

02 VALUES DNS_LOOKUP_IP(‘123.456.789.12’) ;