IBM i, Programming, RPG

Using RPGLE to extract invoice numbers from an alpha string

This morning my nerdish IBM-i Chum Toby, pinged me a whatsapp challenge to write a little RPG code snippet to “extract invoice numbers” from a random string of data. So…. if you had a string ‘INV#10563592 DATED 12/17/19 SO#286045 NOT GOING’ and you knew that this is a shitty text file way of referencing an …

 Read More

IBM i, Programming, SQL

IBM i SQL – Using SUBST to insert data into a string

IBM i SQL – Using SUBST A while ago I had a problem where I wanted to change the first two characters in a table and I used the very simple concat and subst operations to do it with SQL. Today, we had a slightly more complex requirement of updating text in the middle of …

 Read More