Guru: Comparing IFS Directories Using SQL Mike Larsen

​I use SQL almost every day at my job. It may be just a query in ACS, or it may be embedded SQL in an RPG program. A few days ago, I needed to compare the contents of one IFS directory to another. Combining a few different table functions, I was able to develop a nice solution.
In this example, I have a directory that has five text files in it. I have a second directory that has three text files in it, and they are the same documents that are in the first directory. My goal is to identify …
The post Guru: Comparing IFS Directories Using SQL appeared first on IT Jungle. Read More 

Verified by MonsterInsights