From AS/400 to iSeries to System i to IBM i on Power
Leave a ticket on the helpdesk if you cant find what you need or have a request for a new lesson or blog
There are a multitude of ways to check the IBM i OS version on your IBM i System (No it is NOT an AS400 or iSERIES machine – Don’t argue. Don’t!) You can do it from Control Language Programs You can do it from RPG programs You can do it from SQL You can do …
AS400, IBM i, iSeries, Programming, SQL
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 …
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 …
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 …
IBM i, Programming, RPG, SQL, Webservice
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 …
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 …
IBM i, AS400, iSeries, Programming, RPG
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 …