Computers and the IBM i

Computers and the IBM i

In the vast landscape of computing technology, the AS400/IBM i platform stands as a stalwart, offering robust solutions for businesses across various industries. While its roots trace back to the mid-1980s, the AS400, now known as the IBM i platform, continues to...
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...