Join our webinar to find out how.
Visit the Blog for discussions on RPGLE, SQL, API's, CLLE, PHP and web development using IBM i.
View IBM i job postings in your area.
A scratch page put together with multiple examples of stand alone SQL and SQLRPGLE programs.
One of the only IBM i specific online forums that remains free and open to the public. Stop by, join us, ask questions and share your expertise with hundreds of experienced IBM i developers.
Standard labor entry screens provided by XA may be a bit of a challenge to deploy onto the shop floor. They also lack the ability to transact data to MOTRAN in near real time. What we saw happening is that
To start we are running bot a production (MM) & test (TT) environment of XA (MAPICS). We have separated the environments by logical partition on the IBM i. Looking for a way to keep “we” developers out of production, we
I was in doing a full system save on the IBM i today and thought I’d share a few thoughts. We have 1 physical IBM i device that is partitioned so that we have a production and “development” system available
XA – Version 9.2.0 XA (MAPICS) table defiitions
Short example on how to use system-link to update XA (MAPICS) table. This example includes some procedures. System_Link Users Guide the below snippet runs out of the job scheduler. ** Binding directory – “UTLITIES” 2 procedures GETDATE & UPDDAT System-Link
Procedures — Initial guide to creating them in RPGLE Download the source: getdate getdate_cp getdatetst In this example we will provide an example of how to get date values in a multitude of formats. You may pass it a
This program produces the below spreadsheet. It writes XML to IFS which is then read automagically by excel as a spreadsheet. This example can be used to produce multi tabbed spreadsheets. These spreadsheets can contain any/all of the features in
Encrypting data using system API Required Parameter list for Qc3EncryptData Required Parameter Group: 1 Clear data Input Char(*) 2 Length of clear data Input Binary(4) 3 Clear data format name Input Char(8) 4 Algorithm description Input Char(*) 5 Algorithm description
The Retrieve System Values (QWCRSVAL) API lets you retrieve system values. This is for example use only — We do not recommend use of this program to bypass enterprise security policies. In this example system values that are associated with
The term Application Programming Interface (API) can be applied in many instances. By definition, an API is an application-supplied program or procedure that allows an application program, which is written in a high-level language, to access specific data or functions