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.
Utility XSQL :"Compile" SQL objects into desired library - Part.2
3 November 2019
In the first “episode” of this article we learned how to create into a specified library an object built from an SQL script. Here we present a free tool that allows you to run SQL scripts with embedded variables !
Three ways to consume SOAP Web Services on IBM i
31 October 2019
Three different ways of consuming SOAP Web Services from RPG or SQL as well as a real example of XML parsing with XMLTABLE XMLPARSE
---
Roberto De Pedrini
Faq400.com
Last generated spoolfile
31 October 2019
Looking for last generated spool file or other spool files with QSPRILSP API.
