add record type to DNS_LOOKUP table function

I agree with this. I am trying to scrub an email file. The meat of which boils down to me stripping off the domain name from the email, grouping by domain names, and running them through the following:

CREATE OR REPLACE FUNCTION rob.VALID_DOMAIN (

            domain varchar(256)

    )

    RETURNS BOOLEAN

    LANGUAGE SQL

    BEGIN

        DECLARE vIP_ADDRESS varchar(45);

        DECLARE domain_passes BOOLEAN;

        DECLARE EXIT HANDLER FOR SQLEXCEPTION

            return false;

        SET vIP_ADDRESS = null;

        if domain is null then

            set domain_passes = false;

        else

            select ip_address into vIP_ADDRESS 

            from table(qsys2.dns_lookup(SEARCH_NAME => domain))

            fetch first row only;

            if vIP_ADDRESS is null then

                set domain_passes = false;

            else

                set domain_passes = true;

            End If;

        End If;

        RETURN domain_passes;

    END;

-- Test samples

values rob.valid_domain('gmail.com'); -- returns true

values rob.valid_domain('asdflkjasdflh83ff.com'); -- returns false

values rob.valid_domain(null); -- returns false

values rob.valid_domain('a@a.a'); -- returns false due to sqlexception

One domain which fails this, but does have valid MX records is in the url below (aaclightingsales.com)

https://www.nslookup.io/domains/aaclightingsales.com/dns-records/

IBM will use this Idea as input to planning, but no commitment is made or implied. This Idea will be updated in the future if IBM implements it.

Db2 for i development team
IBM Power Systems Development