Using SQL to perform a domain lookup

We all develop our own algorithms to validate email addresses. There must be an “@” sign in the string, there must be a period after that, etc. Most of these I have seen fail due to the domain name part of the email address. There are now Top Level Domains, TLD, (the letters that come after the “dot”) that are longer than three characters. I know of many non-IBM i applications that use a DNS lookup to determine if the domain is active, although this will not guarantee that the domain has email.

As part of the IBM i 7.5 and 7.4 TR6 release is a simple way to do a DNS lookup using SQL.

Before I get started I need to state the obvious: What I am going to show you here will only work if your IBM i partition can connect to the internet. If it cannot then you will be unable to duplicate what I describe here.

The DNS lookup is performed by a Db2 for i Table Function, DNS_LOOKUP, which is found in the library QSYS2. Two parameters can be passed to the Table function:

Read more »

DevOps on IBM i Consultant

DevOps on IBM i Consultant

The job

Our small consultant team focuses on enabling our client’s end to end journey to DevOps for legacy, with opportunities in the areas of 3rd-party solutions integration. We accelerate our clients towards a technology-driven future, leveraging ARCAD software solutions, products, and tools.

Work you’ll do:

Implement, and manage DevOps capabilities using CI/CD toolsets and automation

Ensure DevOps Architecture we build integrating ARCAD Software solutions with 3rd-party players are robust

This is a hands-on role that develops and supports build and release automation pipelines. You will be part of a 4-consultant team that will deploy ARCAD Software solutions.

Manage entire pipelines and working with tools such as Jira, ServiceNow, any flavor of Git, Azure Devops, Jenkins, Ansible, Urban Code…

Install and configure solutions

Remediate gaps and support the automation requirements of continuous integration and continuous deployment

Collaborate and contribute to enhance ARCAD software solutions for DevOps use cases and optimizations

Continually expand your knowledge beyond your defined area of competence in order to gain a complete overview of a technology organization.

Your Skills

Qualifications Required:

Hands on with Shells, Shell scripting basics, CLI, ANT

2-3 years of experience in working on CI/CD toolsets and automation

1-2 years of experience in agile tooling (Jira, etc.), distributed code management (Git, etc.), and deployment strategies that support both iterative & continuous development

Strong problem-solving skills – ability to take a process perspective in solving problems.

Preferred:

Hands-on at IBM I environment

Hands-on at Azure DevOps

Hands-on at Ansible

Bachelor’s degree in Computer Science or related field

This is a remote position. Some travel is required for short onsite customer engagements and for attendance at trade shows when it is safe to do so.

Why join the ARCAD SOFTWARE group?

#Passion #Ambition #Audacity #Agility #Diversity #Optimism #Fun
The keywords of the founding leader he knows how to transmit to the teams!

Do you share these values?
Join the ARCAD TEAM !

Send your application to: [email protected]

See you soon!

The ARCAD HR Team

The post DevOps on IBM i Consultant appeared first on ARCAD Software.

Verified by MonsterInsights