Re: Check for SPF record (from a domain) using RPG or SQL

Good morning,

We have a situation where we need to lookup the SPF record for an email address before using it.

In windows, it would be something like:
nslookup -type=TXT <hostname>

In Unix, it would be something like:
dig -t txt <hostname>

For .Net, there are some projects like ARSoft.Tools.Net (also available as a NuGet Package) where you can do something like:
var spfValidator = new ARSoft.Tools.Net.Spf.SpfValidator();
var mailIpAddress = IPAddress.Parse("X.X.X.X");
var domain = "example.com";
var senderAddress = "sender@xxxxxxxxxxx";
ARSoft.Tools.Net.Spf.SpfQualifier result = spfValidator.CheckHost(mailIpAddress, domain, senderAddress);
There are multiple workarounds for different programming languages and platforms.


How can we do it on IBM i? Is there a way to check for SPF record using RPG or SQL?

TIA,

Juan Concepcion