Open Access Archives - IT Jungle

Guru: Open Access To The Rescue – The Next Step

May 6, 2019 Jon Paris

I recently wrote a tip on using an Open Access handler to enable the creation of flat files in the IFS. In that version of the handler I generated a generic file name and used hard-coded record delimiters and code page settings. I mentioned at the time that I would normally supply these values at run time. In this follow-on tip I describe how the handler can be modified to use the Open Access User Parameter to facilitate this.

The User Parameter is simply specified as a second parameter to the HANDLER keyword. It can be a simple variable or, …
Read more
Guru: Open Access To The Rescue

February 11, 2019 Jon Paris

Recently I came upon a couple of questions on internet lists asking for an easy method to create flat files in the IFS. Not CSV files, but rather simple text files where individual data items are in fixed character positions. Various somewhat convoluted solutions were offered to the requestors, but to me this problem shouted “Open Access!”

So, I set about quickly building an Open Access (OA) handler to perform the task. I find OA really useful for this kind of job because, once the handler is written, creating these kinds of files in the future become a trivial task, …
Read more