Wordle is an excellent website for a some serious lunchtime cyberloafing. It basically takes any string of text, parses it and creates a nice little word-cloud graphic with the most used words. Wordle is a toy for generating “word clouds” from text that you provide. The clouds give greater prominence to words that appear more frequently

Read More

Tinkering with one of my wordpress sites I noticed that Jetpack was unable to connect. The WordPress Jetpack Error says “Server unable to connect with my site http 404” which is nicely vague. Luckily, the excellent support guys over at ICDSOFT quickly gave me the solution: 1: Log into the control panel obviously your control

Read More

SQL works very nicely on IBM i Servers — the added benefit is that we can access the database using SQL from other machines, access it using IBM SQL and also using Native (DB2) File IO. Note, SQL has some features that native database IO does not support – namely huge long table names (aka

Read More

Want to Scan Replace in RPG? In the middle of this RPG program, I want to reformat and replace some values in a big long address field. But for the life of me… I can’t remember how to use the SCANREPLACE built in function in RPG. #Dingbat /me memory circuits need a service methinks. So, like

Read More

IBM i System Reset Button Breaking news from a medieval insider at the IBM laboratory rochest’r, mn – in ‘rd’r to bett’r competeth with the growing competition from microsoft s’rv’rs, ibm plans to installeth a big r’d did reset button on the newly did announce pow’r systems and changeth all ibm i op’rating system ‘rr’r

Read More

From AS400 DLS to IBM i IFS Over recent years, I’ve been playing with the IBM i Integrated File System a lot more than usual. The IFS allows us to use and easily share IBM i Data with Windows/Linux/Apple or just about any other computer on the network. It basically shares native IBM i (AS400)

Read More

TURNOVER Reference Docs for IBM i Programmers Earlier, I was explaining how to use TURNOVER Change Management to some RPG Developers who have spent years using Turnover but who had never used the Programmer Worklist Function. I was mildly surprised at the manual technique that was being used to check out each object, adding to

Read More

Have you ever wanted to extract some data out of an IBMi/AS400 file using SQL and then email that data to someone as an Excel Spreadsheet? Now you can… all from one IBMi command without having to write any CL code to do it. Projex4i: DSTDTA command now handles SQL STRINGS for selecting data I

Read More

The AS/400 does not exist anymore Discussing a data interchange process with a software vendor today (who shall remain nameless), they told me: … our product talks to AS400 but I don’t think it has experience of iSeries or IBM i…. Customer Support Bloke for XYZ Company *sigh* I am not telling you the company

Read More

“Remember, you are on the West Coast now. You are expected to have and use at least one of these….surf board, sail board, skate board. Walking is permitted only in unusual circumstances. Generally, you should be running, biking, skate boarding etc. to get from one place to another on terra firma. That is just a

Read More

Now, before you get all bent out of shape and point your grubby little index finger at me cackling “you called it an AS400 na-na-nu-na-naaah“, I do have a legitimate reason. It’s a shallow SEO based one (the grey haired brigade keep searching for “zip AS400 library”) but it’s legitimate. I only used the wrong

Read More

Using SQL in RPGLE programs is easier than you think. Making the move from RPG native file IO to SQL database IO is really quite straightforward:  Changing from good old READE loops to SQL FOR Loops simply means using the SQL CURSOR function. SQL has a groovy way of referring to what the stuff that

Read More