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

Read More

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

Read More

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

Read More

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

Read More

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

Read More