RPG EXAMPLE to read NUMERIC from ALPHAMERIC AKA: how to select only the number from an address in a field, or file data A little while ago, I wanted to extract out the numerics from a string of data: For example (a) if I feed in a phone number like “(540)-123 – 1234” but I just

Read More

SQL Tables with Indexes and Views are faster than DDS Phsyicals and Logicals. #HONEST SQL is a wonderful beast for quickly getting data from huge tables (aka Files). The trouble with SQL is that it’s so very simple to use; programmers get lazy and sometimes forget to do the analysis to make it as simple

Read More

Is SQL faster than CPYF Native IO? For the longest time I’ve heard about the performance difference between a true SQL INDEX and a DDS ACCESS PATH generated index on the IBM i operating system (or ‘OS400’ which was a ten year old, but very commonly used version of the the same OS). But is

Read More