This procedure was written to retrieve the IP address of a device. This can be used to identify a specific device. For example if you have an application that in a manufacturing environment that is assigned to a facility (work
Get IP Address
Check IFS/Server for a document
This procedure was written to check for the existence of a table on either the IFS or a network server. Using the c function Access for the IFS and for the network FTPing to the server and attempting a rename to
SQL Vs. QUSRJOBI (Retrieving Library List)
Using QUSRJOBI to retrieve Library list vs SQL. We will be adding additional examples of how SQL is taking over, where once only API’s could do the work. Simplifying code and helping to build a stronger developer, with the tools
SYSTEM – API CMD Processor
system() is a runtime C library function that performs the same purpose as the QCMDEXC API. With system() you pass a pointer to the command string and it is executed, no need for the for the command string length. The API is a good
Caller – The Detail(s)
Caller_CP – This procedure returns the name of the previous program. If called from command line would be – RETURNPROGRAM = ‘QUOMAIN ‘ Use this process of a copy book containing the PR statement and in some cases a shareable
XA (MAPICS) SQL to pull 10 levels BOM
I needed a quick way to pull Bill of Materials (BOM) for a group of finished goods to help calculate turns of raw material. I borrowed this from WIKI A bill of materials or product structure (sometimes bill of material,
XA (MAPICS) Facility Time Entry
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
Refresh IBM i test partition
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
Updating Planning Date XA (MAPICS)
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
Get date in multiple formats
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