PTFs and PTF Groups: Are you up to date? Let's check via SQL
14 December 2019
Which PTFs or PTF Groups are installed? Are there new updates available to install?
And is the firmware updated?
These questions can be answered with a few SQL statements
Merge (append) several PDFs into one (Python on i)
8 December 2019
Getting one PDF from different IFS’ PDF files. Python, PyPDF2 on IBM i
---
Roberto De Pedrini
Faq400.com
Smarter SQL functions with control statements
1 December 2019
With some SQL special statements we can build a function so that it can perform business logic as in a “real” program written in a structured language. Let’s see how !
Up and down (EN)
30 November 2019
When did our IBM i shut down and last? And how long did it take to go out and turn on?
In this article I suggest a simple API and some ready-to-use SQL statements to extract information about the last shutdown and power-up of IBM from the system
This information is contained in various "angles" of our operating system (system values, system operator messages, history logs, …). With a few SQL statements we display them all together.
IBM DeveloperWorks Connections sunset
4 November 2019
IBM announces to close DeveloperWorks Connections … we are not … and you?
---
Roberto De Pedrini
Faq400.com
STRTCPFTP how to use it to run fast FTP
3 November 2019
A simple way to FTP your files from or to your IBM i.
