Peep show… peep show… bloody brilliant … nuff said  Arguably my favorite laugh-out-loud sitcom of all time. Peep Show is a British sitcom starring David Mitchell and Robert Webb and it filmed from the unusual ‘through-their-eyes’ point of view. You can also hear the thoughts of the person who’s eyes you are looking through. Saying

Read More

If there was a quick and easy solution to “how to quickly become a productive RPG IV and ILE programmer” then all of us old AS400, iSeries and IBM I developers would have gobbled up that solution in double quick time. But Wait. There might just be Ne. Drinking Tea. If you have read any

Read More

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