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
RPG Subprocedure Tips and Techniques The use of subprocedures in your applications should be on everyone’s “to do” list this year. You don’t need to drop everything and rewrite your applications to take advantage of subprocedures and many other benefits that the Integrated Language Environment (ILE) offers. However, when writing new applications or performing major …
Restore and Rescope Logical Files When you restore a logical file, the system uses the description for the logical file to establish its relationship with the based-on files. For example, database views or indexes are logical files. You can restore a logical file to a library different than the library for the associated physical file. …
AKA Command Line Access from System Request 3 If you are an IBM I software developer or power user – then that headline will make sense. In fact, I can guarantee that’s the only reason you discovered and are reading this page. System Request 3 makes every RPG programmer twitch 3 fingers ready to reach those …
What is TurnOver? Simply Put – TURNOVER is an IBM i Application that controls the flow of software development from writing code to testing to QA/UAT approval to installing on remote IBM i Systems. It has a long history dating back to the AS/400 and iSeries systems. TURNOVER is Change management for integrated IBM i, …
How do I change an IBM i Webservice from SOAP 1.2 down to SOAP 1.1? And more importantly… Why would I want to do that? A client asked me “Can you change some of our IB i Webservices to use SOAP1.1?” Apparently, some MS Webservers are having problems with SOAP 1.2 when connecting to IBM …
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 …
Ever wanted to find your IBM i OS Version in RPG? Following on from this old blog about how to find the OS version from a CL Program (and when I say OLD I mean from back in 2009, when I was still young and crispy.. as opposed to how I am now; old, wrinkled …
IBM i Housekeeping 101 – Deleting old Journal Receivers Following on from the blog I wrote about “What is an IBM i Journal?” We know that IBM i journals record what happens to files, and we know that this record is kept in these things called journal receivers: Now – since a journal can record …
Email an IBM i File as a CSV Sample IBM-i Control Language Program to take a physical file (aka SQL Table) convert it to a CSV Spreadsheet and email to someone… somewhere.. First let’s create a nice little CMD wrapper to give us a smarter way of calling our CL code: and the executing CL …
SQLRPGLE Shorts – How to Call QCMDEXC with IBM i SQL Surely every RPG programmer is familiar with the QCMDEXC *API for exciting any IBM i Command from within any HLL (High Level Language) program. What is QCMDEXC? The Execute Command (QCMDEXC) API runs a single command. It is used to run a command from …
AS400, IBM i, iSeries, Programming, RPG
DSPF Indicator Command Keys in AS400 RPG (… and iSeries and IBM i obviously) Ever since my days at JBA, I’ve used the old-fashioned function key indicators to handle internal Function Keys selections, or Command Keys as they were known in the System/3x days. These PFKEY ranges from keys 1 through 24. Most programmers used …