Who's calling my program ?
8 April 2020
Sometimes you may need to know which program has called the program that is currently running. With SQL and DB2 services, knowing that it is very easy!
Exploring the IFS with DB2 services
23 February 2020
The numerous DB2 for i services recently have been enriched with a new category, that allows you to poke around in the IFS directly with SQL
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 !
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 !
"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.
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?
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 !
