Convert multiple RPG “Chain”, “Read” and “DoW” operations to one simple SQL statement

Easy way to consume and process JSON on IBM i using SQL

When interfacing data between different entities the JSON or JavaScript Object Notation format is often used because it creates a smaller payload than some other data interchange formats and can be faster to process. JSON stores data in arrays or associative arrays of...
Using a domain socket for phpMyAdmin

Using a domain socket for phpMyAdmin

How to change phpMyAdmin to utilise a domain socket when conecting to MariaDB on the IBM i We use phpMyAdmin to do some important database adminstration on our MySQL databases. phpMyAdmin comes as a free piece of software developed using PHP. The software allows us to...
Adding jQuery AutoComplete to an HTML input form field using Ajax

Adding jQuery AutoComplete to an HTML input form field using Ajax

How to add autocomplete functionality to an HTML input field to aid selection and permit effortless form field pre-population on the IBM i When presenting users with an HTML form to be filled in it can be helpful to present the user with an autocomplete list of...
Create a QR code and email as an attachment from the IBM i

Create a QR code and email as an attachment from the IBM i

Creating QR codes and emailing them in a pdf as an attachment from the IBM i QR codes are very much in the news at the moment. QR codes are basically 2D barcodes but with the ability to contain a greater amount of information that can be read much faster and more...