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…
SQL: How many rows in my select statement?
30 September 2019
Sometimes we need to know in advance how many records will be fetched from an SQL query. SQL already knows everything … let’s see how to do it !
RTVDSKINF / PRTDSKINF Goodbye!
30 September 2019
Let’s summarize the operation of these two commands: RTVDSKINF is the command that collects information relating to the disk space occupied by objects, libraries, … Once launched, it is necessary to wait a while 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.
SQL: Playing with CROSS JOIN
24 September 2019
Cross Join, let's try to understand when and why to use this Join type
