Consuming REST web services with basic authentication
20 October 2019
It happens more and more often to come across the request of having to manage integrations with applications, potentially installed on any type of platform. On the one hand this kind of activity scares us…
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?
Building IBM i WEB-APP with Python and Flask
13 October 2019
Flask is a fantastic and very light Python framework for creating powerful web applications and is a great tool for creating your own websites in a dynamic and interactive way.
IBM i Technology Refresh 7.4 TR1 and 7.3 TR7
11 October 2019
Welcome to this new IBM i Technology Referesh TR1 for 7.4 and TR7 for 7.3. The announcement is only two days ago, October 8, 2019, Technology Refresh for IBM i, TR1 for 7.4 and TR7…
---
Roberto De Pedrini
Faq400.com
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 !
