Month: June 2023

​This us another post that came from a question I was asked by a reader of this blog. The question is:

I have multiple files in an IFS folder with similar names, each has a timestamp at the end of the file name to make them unique. How can I read all the files and write the contents into one file?

Fortunately there are two SQL Table Functions that can help me do this:

IFS_OBJECT_STATISTICS:  To make a list of the files
IFS_READ:  Read the contents of the files

The rest is pretty straightforward SQL and RPG.
Read more » Read More 

​Using APIs Instead of Direct Database Access In today’s intricate business landscape, IT staff are in a constant state of intertwining multiple technologies on different platforms. Services and applications, internally and externally, need to be united to bring business value and innovation. Linking these various and ever-changing systems together to deliver modern solutions is of Read More 

​Welcome to your #IBMi update, your monthly update into what’s been happening in the IBM i community, with Andy Nicholson from Proximity. You can watch the video below or read the full article underneath. Watch the Video:  Full Article: i-Power, Common Europe and a 35th Birthday! Your monthly update into what’s been happening in the
The post IBM i Update: June 2023 appeared first on Proximity. Read More 

​ This document describes how to use the system service tools macro SYSTEMHEAPS output to determine the address and current size of these heaps.  This support can also be used to monitor for growth of these heaps.   Read More 

​ Read More