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.
"Compile" SQL objects into desired library - 1
20 October 2019
In SQL scripts for DDL-defined objects (tables, views, indexes, etc.) it is not good to explicitly specify library names. We provide here a small utility command that allows to “compile” all the objects defined with SQL script specifying the destination library.
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?
