Join me on a mission to connect to a SQL Server database from IBM i This will be a growing blog… I’m going to use this to record a diary of sorts, chronicling my adventures in accessing and reading a Microsoft SQL Database direct from an IBM i application. Apparently, if the bods at Microsoft

Read More

Verify MariaDB – MySQL on IBM i Following Part 2 – where we installed IBM i MariaDB (MySQL) – the next burning question is “OK, so it looks like it installed, so how do we check it and use it?” Me – with a coffee Now that we have MariaDB – MySQL is on your

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

Substring in RPGLE SQL This morning, I had to make a little change to an RPG4 program to let it respond to a new parameter being passed into it via JSON. This value had to be stored in the first character of a field in a physical file in the database. Simple Logic and we

Read More

How does SQLRPGLE USRPRF(OWNER) work with RPGLE Programs? If you compile IBM i programs using USRPRF(*OWNER) then they will adopt the security setting for the program owner at runtime. #sometimes If you are calling an IBM i SQL program, that has been compiled with USRPRF(*OWNER) you may find that it does NOT adopt the security

Read More

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 it true? I know that SQL creates

Read More

I’m a big fan of WDSC7 (Websphere Development Studio Client for Windows) for my RPG/CL/DDS/SQL/whatever coding when I’m using windows.. but there are a few others out there. I would love to use IBM’s RDi (Rational Developer for IBM i) but while IBM insist on charging around $900 for the program it puts it firmly

Read More