GPS-Enable the Addresses in Your Database! This was originally in a wonderful article in the now-dead mcpressonline website. I had saved it to my hard-drive of saucy IBM i Programming techniques, so here it is – resurrected from the dead. Original Source – http://www.mcpressonline.com/programming/rpg/gps-enable-the-addresses-in-your-database.html Do you realize how much your business can do with GPS …

Read More

We are always trying to find the large libraries on the machine! Hunting down the big libraries in an IBM i system (the artist formerly known as AS/400 or iSeries) is a quest with several critical motives: Diving into the vast ocean of libraries in your IBM i system with a proactive snorkel can unearth …

Read More

Use the Retrieve Job Attribute (RTVJOBA) command to snaffle the job’s run type from the attributes. Seems pretty obvious right? One little niggle was that the RTVJOBA passes back a char(1) value for the jobtype where ‘0’ means batch and ‘1’ means interactive. But, I want to be able to neatly compare a logical value …

Read More

I was updating a little RPG utility this morning to add some more detail to a spreadsheet it generated. Adding the Library Description will help the non-propeller heads who read this stuff. This is super easy to do with a single line of SQL added to your RPG program. What is this spreadsheet you are …

Read More

Developerworks Connections is dead As I was waffling this morning about the sad demise of IBM Developerworks Connections Wiki – here is another excellent article that discusses various extensions to IBM Rational Developer for IBM i – How to Extend RDi (#RDi) So here it is, re-posted before IBM can hide this wonderful source of …

Read More

I was discussing the benefits of RDi with a colleague this morning (I’m a bit of a Rational Developer fanboy) because he is trying to justify the huge annual cost of the tool with The Management: nearly $1000 per year per person! A price tag that is #bloodypreposterous. But, I will rant about that in …

Read More

IBM i Data Obfuscation – Making Data Foggy Murky and Squinty A little while ago, I wrote a data obfuscation tool – which I decided to call Data Fogging. This is specifically to solve the data privacy problems that we face when we want to suck down real data from production environments to our development …

Read More

So, I just did an upgrade of the BCD Software GUI Client (now owned by Fresche Legacy by the way) for a client. This upgraded their older version of Presto to PRESTO 8.1 Server. This also comes with a new Presto Client and Screen Designer adding some nice new tweaks. Compulsive Library Naming Tendencies The …

Read More

Talking to a colleague this morning, we were discussing a vendor supplied series of spreadsheets (in CSV format) that his team needed to process. I was surprised to see there were hundreds of files in this folder and he wanted to list them, and assign different files to different people. “What’s the best way to …

Read More

AS400 DLS vs. IBM i IFS If you answered YES to any of these questions then I’m not surprised you’re confused! Sadly ,there are still a handful of people in the both the technical and business worlds that use the wrong names for (1) your IBM i Power System and (2) software running on your …

Read More

IBM i ACS 5250 EMULATOR FONT What’s in a font? Lots of things make our life easier as IBM i Programmers. Working with a clean, easy to read 5250 terminal mode is one of the them. I’m a big fan of Mochasoft terminal emulator, but growing appreciation for the new IBM i ACS (Access Client …

Read More

AS400 hundred year date format I had to pull records from two files with a matching date value in each file. To make things interesting, the date on one file was stored in timestamp format and the date field in the other file was stored in hundred year date format. SQL (and QUERY400) can very …

Read More