Leave a ticket on the helpdesk if you cant find what you need or have a request for a new lesson or blog
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 …
How does IBMi Handle job inactivity (QINACTITV) In recent releases, IBM has made several improvements to IBM i‘s the handling of the Inactive Job Time-Out Interval (QINACTITV) to enhance accuracy and performance. Here are some key changes: QINACTITV – Inactive job time-out. Specifies when the system takes action on inactive interactive jobs. The system value …
What is an IBM i Job Description? An IBM-i job description (JOBD) defines runtime information about the Job that is submitted using it. It’s been this way since the AS400 and iSeries machines of years gone by. A JOBD contains information covering things like: Job queue to be used by the Job, scheduling priority, routing …
How can I use IBM i authorization lists to control access? IBM i (AS400/iSeries) authorization lists are a powerful tool for controlling access to objects within your system. Let’s explore how you can effectively use them: Remember that authorization lists provide a flexible and efficient way to manage security. By using them effectively, you can …
How to spot a Scammer on Etsy? I like to pride myself on being cautious with online purchases. Scammers come in all shapes and sizes and I often sigh with exasperation when I realise that one of my friends or colleagues has accidentally fallen for a scam. If it looks to good to be true, …
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 …
Another work week comes to an end. Another week when an executive asked “I’ve heard both names, do we have an iSeries or an AS400?” Another work week, where I had to gently explain, “We have an IBM POWER SYSTEM, running an operating system called IBM i.” Another work week, where I had to follow …
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 …
How to Download IBM i SQL Results As CSV I had to run a rather interesting SQL statement to download journal information: What does this do? Essentially, this SQL snippet retrieves journal entry information for the given journal and the file that is journaled. Running this in the IBM i ACS SQL script explorer gives …
