Reading spool files with SQL
13 October 2019
To read the contents of a spool file you can make a program that runs the CPYSPLF command and then reads the output file. But why write a program when SQL can do all the work?
AFPRSC this unknown (keyword)
9 October 2019
Starting from V7R1 IBM has released the keyword AFPRSC usable at record level. It is useful in case you want to insert images, pdf and AFPDS objects natively in spools without the need to use…
Zip / Unzip via QSH
30 September 2019
Have you ever had to generate a zip file and then send it via mail / ftp / … maybe starting from a folder of the IFS populated with files? Here is a method to…
DB2 Import Text/CSV files
24 September 2019
There are various methods and contexts in which it is necessary to acquire data from sources outside DB2. In this article we focus on importing data from CSV type text files.
Safe sources with the debug encryption key
17 September 2019
Source-level debugging view options allow others to view our source code. Let’s see how to protect our sources with a handy compile option
