IFS profile disabled? So, I have a love/hate relationship with IBM i’s integrated File System (IFS) Does you keep getting asked for username and password when accessing a windows IFS share? Are you confused why the share to your IBM I Server cannot be viewed in Windows Explorer? Can you view the IFS from one …

Read More

RUNSQLSTM – Run SQL Statement When you do the RUNSQLSTM to create your SQL Objects – Do not qualify library names but use the Turnover variables just like you would define PDM variables: Turnover uses the DFTRDBCOL column “&LI” to populate the other *library* variables. Most shops I’ve been to use QSQLSRC to store the …

Read More

UPDATE JULY 2020 – IBM CHANGED THE RULES AND NO LONGER OFFER THIS SERVICE TO ALL DEVELOPERS 🙁 Since I wrote this blog way back in 2016, IBM have changed their minds and now only offer the “TRY an IBM i ” service to Business partners. But fear not — If the phrase “Free IBM …

Read More

“How do I check the status of the System 21 (JBA/GEAC/INFOR) background jobs from an RPG program?“ I was asked to hack together a quick little routine to check the status of the System21 background jobs, for some specific web-service calls that were talking to an IBM i system running INFOR’s System21 ERP. Hmmm… That …

Read More

RPG is not a Rocket Propelled Grenade RPG2 is that Logic Cycle Thing RPG3 is the System/38 version RPG400 is the revamped RPG3 that came with AS400 ​everything after that is RPG… unless its ILE then its RPGLE or sometimes RPG4, or its free format so its RPGLE /Free… or its SQL so its RPGSQL …

Read More

Preparation Notices: Expect 30 – 45 minutes for per installation. Installation requires Administrator permissions and a computer reboot(s). If MS Office, Office360 or other products are required, it is recommended that all applications be installed before Client Access is installed. If this is an IBM Client Access upgrade, the installation will attempt to un-install any …

Read More

Today, I was talking *techie* to a colleague in I.T. who still calls the IBM i Operating System – ‘The AS/400’. (but dont get me started on that) We bumped over a few ‘technology sleeping policemen’ during the conversation. Software is easy to upgrade. Mindsets are sometimes overlooked. This reminded me of the importance of …

Read More

Do you want to play with an IBM i System? Do you want to test compatibility with old AS400 and iSeries applications? Do you want to fiddle with IBM i? Try pub400.com – the famous public IBM i server for ! PUB400 is the successor of PUB1 – the worlds famous public AS/400 system with …

Read More

What is the best IBMi (AS400) 5250 Terminal Emulator? The IBM i System (aka i5 aka iSeries aka AS/400) uses something called 5250 to stream its data to a terminal, often called a green screen. You’ve seen this clunk old terminals in black and white scifi movies – well we still use them. Kind of. …

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

I installed the first Technology Preview (aka Beta) for the new version of IBM i Access (aka Client Access) a few months ago. I really liked it, but was working on a clients project which had different standards for TN5250 and a few other things. So, to align with my team mates I worked with …

Read More