Category: Technical Articles
-
Eclipse AI Chat Integration
My good friends at Remain Software have just released an AI chat integration feature for Eclipse and Rational Developer for i . According to their website, ‘This tool leverages the power of AI to provide contextual suggestions, code snippets, bug checking and documentation proposals. Empowering you to write code faster and more efficiently.’ Yes, it…
-
A screen a story – A User Reporting Slow ODBC Performance
In my last article I wrote: “IBM i Services allows a modern system administrator to move away from having to use 5250 emulation, not because you should, but because using IBM i services is quicker in getting the job done. In my next episode of a screen a story I am going to demonstrate that…
-
A screen a story – The Contact Information National language version
Recently Scott Forstie created an SQL script allowing you to create a procedure with which it is a piece of cake to review the special instruction PTFs. What the link is between the contact information and the PTF cover letters is something I will explain later on. Please allow me to focus on the special…
-
Environment Variables
The IBM i operating system is highly dependent on environmental variables, which can have a significant impact on its performance. In this article, we will dive into the various environmental variables and their effects on the IBM i. What are environment variables? Let me start at the beginning, what are environment variables? Environment variables allow…
-
A screen a story – The Run SQL Scripts bottom bar
If IBM is following the same schedule as it has in previous years it is fair to say that a new version of IBM i Access Client Solution (ACS) is waiting just around the corner. In the past April was the month in which a new ACS version was released as a part of a…
-
DB2 for i Multisystem
In this article I will be taking a look at a feature we should all be installing, and using, on our IBM i servers. As I mentioned in a recent article I wrote on the advance job scheduler (which can be found here), IBM announced in May 2022 that half a dozen previously chargeable licensed…
-
A screen a story – What does “move active records” mean?
The latest Technology Refresh (TR) for IBM i 7.4 and 7.5 has something new within them for reorganizing a file. If you have lost count of the TR levels IBM i 7.4 is at TR7 and IBM i 7.5 is at TR1. Every time a new TR is announced it can be overwhelming with the…
-
Node-RED & Security
I gave a quick demonstration of Node-RED to a client recently and I didn’t get the response I was expecting. On bringing up the Node-RED browser interface, the first question I got asked was why doesn’t Node-RED use a TLS (Transport Layer Security), or SSL (Secure Socket Layer), connection to the server. Great question, I’m…
-
Node-RED & Bank Holidays
In a recent training course I gave to a UK bank, we were covering web-services and I showed how we can get information from a reliable source and then store it in our database. They informed me that they still manually input UK Bank Holidays into a table. This was a task that they had…
-
A screen a story – What does this button do? Part II
In my last article A screen a story – What does this button do? The SQL button was used to retrieve SQL statements which I then tweaked to get the job done. The purpose of it all was to build an SQL script to automate changing the object owner of a printer, object type *DEVD.…
-
Node-RED & IBM i
In my last article I wrote about the hoops we had to jump through to get the DB2 for i Node-RED adapter installed. In this article, we will be taking a look at how we use that adapter and also how we can run IBM i commands from within our Node-RED flows. All very useful.…
-
Node-RED & DB2 for i Connector
I know I said in my last article that was the end of my little project on the Raspberry Pi with Machine Learning talking to the IBM i. Well since my last piece I have found how to correct a couple of the moans I had with Node-RED on the IBM i. My last article…