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 

IBM i PTF Guide, Volume 25, Number 25 Doug Bidwell

​Happy 35th birthday to the AS/400! We hope that you take a moment and commemorate this wonderful platform that has given us so much over the years, and that we all have given so much to.
It is one of those mercifully quiet weeks, so enjoy.
The news this week is that Navigator will now use Java 17 if available (on 7.4 and 7.5).  Install Java 11 or Java 17 and latest Java group PTF to run Navigator with these versions of Java. Details on Java at: https://www.ibm.com/support/pages/node/6437873
Here is the rundown of PTF Groups by IBM i release …
The post IBM i PTF Guide, Volume 25, Number 25 appeared first on IT Jungle. Read More 

Verified by MonsterInsights