Jul 21, 2025
Have you migrated your S36 MAPICS II files to native IBM i DB2 tables but kept the old MAPICS definitions and need to be able to do arithmetic in SQL on the malformed transaction quantity fields? The IBM MAPICS (Manufacturing, Accounting and Production Information...
Feb 8, 2024
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...
May 2, 2022
We’ve all got stacks of legacy code that has a huge amount of business logic locked away full of those pesky do loops with their setll’s and reads followed by endless hops off to do some chain statements grabbing all the accompanying supporting data. Well...
Mar 27, 2022
ctime is a good way to get the date narratives day name and month name in short form eg Sun Mar 27 15:39:23 2022. This UNIX api returns the names abbreviated to the first 3 characters eg Sun, Mon Tue and Jan, Feb, Mar etc. If the current time is required then using...
Mar 15, 2022
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...
Nov 11, 2021
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...
