Leave a ticket on the helpdesk if you cant find what you need or have a request for a new lesson or blog
IBM i, Programming, RPG, SQL
How does SQLRPGLE USRPRF(OWNER) work with RPGLE Programs? If you compile IBM i programs using USRPRF(*OWNER) then they will adopt the security setting for the program owner at runtime. #sometimes If you are calling an IBM i SQL program, that has been compiled with USRPRF(*OWNER) you may find that it does NOT adopt the security …
RPG PROGRAM USER(*OWNER) – Adopts the object owner level of Authority Most IBM i Programmers are aware of the USER(*OWNER) compile setting — anyone calling this program will adopt the authority level of the program. So if a program is compiled by user QSECOFR and USER(*OWNER) then anyone calling that program will automatically be elevated …
Ever had to populate the *LDA in correct layout for JBA ERP Modules (aka GEAC aka Infor System21? Here is a quick and easy JBA System21 *LDA – RPG Example written in RPGLE **FREE format. Here is a simple RPGLE program to setup the *LDA priot to running a few little INFOR SYSTEM21 extraction routines: WEBSETLDA …
LMS 7.3 – IBM i Lodging Management System In the words of Jesse from the Fast Show (showing my age there) — This week I will be mostly preparing to upgrade LMS 7.1 to LMS 7.3.3 So, this Las Vegas Casino uses Turnover V100 to manage software change management across its IBM i Systems. I …
IBM RDi is a great IDE for IBM i Programmers writing source code in RPG, RPGLE or CL. But, setting up the editors RDi library list is not that obvious acronym alert — (1) RDi is IBM’s Rational Developer for IBM i and (2) IDE is Integrated Development Environment – just a poncy way of …
What is a single page subfile? A single page subfile is a SCREEN OF DISPLAYED DATA, loaded one page at a time. The displayed data is the number of records that are loaded and displayed at a time. In other words, in a single page subfile, all loaded records are displayed at a time. We …
By using MSGCON (message constant) keyword. You use MSGCON, a field-level keyword to declare the text for constant fields is contained in a message description. Years ago, this was used by a lot of companies to create multilingual display files. The idea was that you could remove the ENGLISH language fields from every *DSPF and …
THIS IS FOR LMS 7.3.4 Hot Fix PLEASE SEE NOTES AT THE END OF THESE INSTRUCTIONS FOR CALL PROGRAMS Please find the link below for the latest hot fix 7.3.4 library and the associated hot fix log. Restore the savf to QGPL and follow the below instructions to install. Please note that there are display …
So, I was trying to help out a buddy in the land of IBM i today. He was trying to install the most recent Beta of Projex4i IBM i Powertools on a clients IBM i Server. The problem he was facing was two fold (a) the connection he was using was very slow so trying …
What is Ingress? It’s a game. A huge MMO that is played world wide. It’s played outside, in the real world, using any mobile device. It’s using google maps to show a real world view. Ingress is an Augmented Reality Game (ARG) where you have to go to certain locations and hack portals. There are …
IBM i, Programming, RPG, SQL
Let’s look at a quick little example RPG email validation program – SQLRPGLE ILE There are lots of code snippets, example programs, and long waffling discussions in internet land filled with pointy-headed AS400, Series, and IBM i programmer chaps (and chappettes) arguing about the best way to “validate an email address in RPG”. I know …
RPG EXAMPLE to read NUMERIC from ALPHAMERIC AKA: how to select only the number from an address in a field, or file data A little while ago, I wanted to extract out the numerics from a string of data: For example (a) if I feed in a phone number like “(540)-123 – 1234” but I just …
