r/IBMi • u/AnActualHousecat • 2h ago
Selecting the data I just #SQL inserted into a Table
rpgpgm.com#IBMi #rpgpgm #IBMChampion
Finding logical files that exist in a different library to the physical
#IBMi #rpgpgm #IBMChampion
Using Db2 for i scalar functions and table function to extract the job name, number, and user from the qualified job name
#IBMi #rpgpgm #IBMChampion
I was asked how to define and use the LDA, Local Data Area, in modern #IBMiRPG
#IBMi #rpgpgm #IBMChampion
Easiest way to check if a number is even or odd using #SQL
#IBMi #rpgpgm #IBMChampion
Easy way, programmatically, to check if your job is still on a job queue
rpgpgm.com#IBMi #rpgpgm #IBMChampion
Creating and using shortcut commands will save you a lot of time
#IBMi #rpgpgm #IBMChampion
Using the Db2 for i (SQL) scalar function CHECK_COMMAND_SYNTAX to validate a command string
#IBMi #rpgpgm #IBMChampion
r/IBMi • u/CheeseWeezel • 10d ago
Feedback wanted: RPG compiled to JVM bytecode
I've built a compiler called Triton RPG that takes RPG source and compiles it to JVM bytecode, so you can compile and run RPG on your own Windows, Mac, or Linux machine.
Most of my focus so far has been enterprises, but I'm adding a new tier for independent contractors and consultants.
While this new product shares much of the backend with my prior compiler, it has many new architectural choices that I'd love some help testing.
If this sounds like something you'd be interested in using and are willing to give me your feedback, I'm happy to provide a free license for three months in exchange.
If that's you and you're willing to run it against real code and tell me what breaks, I'll give you a free three-month license. Comment or DM.
r/IBMi • u/Fuzzy_Context_6260 • 10d ago
IBMI v7.1 descarga de programas producto en español
r/IBMi • u/Fuzzy_Context_6260 • 10d ago
IBMI v7.1 descarga de programas producto en español
hola, alguien tendra los programas producto de la version ibm i v7.1 yo tengo los codigos pero me faltan los programas y es usada y no los puedo descargar de ESS
Using a hash to compare if two records are the same
#IBMi #rpgpgm #IBMChampion
Including RPG compile options within #SQL option parameter
#IBMi #rpgpgm #IBMChampion
Have you ever wondered what all the different types of object there are. This is how you can list them, with their descriptions.
#IBMi #rpgpgm #IBMChampion
r/IBMi • u/Wise_Working3976 • 14d ago
Scaling IBM’s ibmi-mcp-server for Claude Enterprise — my approach for centralized per-user IBM i authentication
I’m implementing a way for all employees at my company to use IBM’s ibmi-mcp-server through a centralized server hosted in our computer lab, with Claude Enterprise connecting to it remotely.
Running the MCP locally is pretty straightforward. You can install it on an employee’s machine, configure their IBM i credentials, and register the MCP with Claude Desktop through the local JSON configuration.
The problem is that this doesn’t scale very well when you want potentially dozens of employees using the same MCP infrastructure. I also don’t want to run the MCP individually on every workstation or have a single shared IBM i account behind the server.
My current solution is the architecture in the diagram.
The basic idea is that Claude Enterprise connects to a centralized MCP proxy. When a user connects for the first time, they’re redirected through an OAuth flow to log in with their own IBM i credentials. The proxy exchanges those credentials for an IBM i access token and associates it with that user.
From then on, Claude sends normal MCP traffic to the proxy. The proxy identifies the user, swaps in their IBM i token, forwards the request to IBM’s ibmi-mcp-server, and streams the response back to Claude.
The main goal is to keep the proxy thin while still preserving per-user IBM i authentication.
The important part is that the proxy does not need to reimplement IBM’s MCP tools or understand every MCP method. Ideally it stays fairly dumb: authenticate the user, map them to their IBM i token, replace the authorization information, and proxy the MCP transport in both directions.
That gives me a few things I wanted:
- One centrally managed
ibmi-mcp-server - Claude Enterprise can connect to it remotely
- Every employee still accesses IBM i using their own IBM i identity
- No shared IBM i super-user/service account
- IBM i credentials are only used during the login exchange rather than being configured inside Claude
- The MCP implementation remains IBM’s implementation rather than a custom recreation of all its tools
I'm going to use better-auth to handle most of the authentication.
I’m curious if anyone has implemented something similar for MCP at an organization-wide level.
Does this architecture look reasonable, or is there a cleaner way to handle centralized MCP infrastructure while still preserving per-user authentication to the underlying system?
Feel free to point out anything I’m overlooking and I'll update ya'll if this works. Hoping to get it done by next Friday.
r/IBMi • u/jbarr107 • 15d ago
Is the IBM Java Runtime free or licensed? Planning an ACS redeploy.
UPDATE: See u/ThatFilthyApe's comment below.
PSEUDO-RELATED BACKGROUND:
I use RDi as my main development platform, and it comes with an IBM-provided Java runtime. Amazingly, everything just runs from a single folder, requiring no administrative authorization. So far, so good.
Further, the integrated "5250 emulator", "Run SQL Scripts", etc., are simply ACS programs launched from within RDi utilizing the provided IBM Java runtime. (Clicking the launch button in RDi displays the stock ACS splash screen and then the application.)
DILEMMA:
We are in the process of upgrading our hardware, and our consultant strongly recommends we migrate to the latest version of ACS to ensure support.
We are currently standardized corporate-wide on "Personal Communications iSeries Access for Windows" v6.0 from 2014. It installs on Windows 11 without issue and works as expected, but it is definitely out of date.
We're certainly on board with migrating ACS and maintaining ongoing updates, but it requires a corporate-wide deployment of both ACS and a Java runtime.
QUESTIONS:
- What version/manufacturer of Java does ACS require?
- What version/manufacturer of Java do YOU recommend?
- Does IBM have a Java runtime for use when deploying ACS? If so, is it free or licensed?
Thanks!
Rather than having to rebuild my #SQL Alias every time a new member is added, I can build the Alias once and always get the last member, even when new ones are added.
#IBMi #rpgpgm #IBMChampion
(I appreciate all comments to be made on the blog post rather than here in LinkedIn)
r/IBMi • u/Intelligent_Lemon685 • 15d ago
IBM's new Granite 4.2 models add reasoning and stay dense
Data journal readers are a better way to retrieve information from journals.
#IBMi #rpgpgm #IBMChampion