Code400

YOUR EXTENDED TEAM

Impact Analysis does not have to take days.

Join our webinar to find out how.

Registration Now

Code Samples

Visit the Blog for discussions on RPGLE, SQL, API's, CLLE, PHP and web development using IBM i.

Code Samples and Discussion

IBM i Job Postings

View IBM i job postings in your area.

Job Postings

SQL on DB2

A scratch page put together with multiple examples of stand alone SQL and SQLRPGLE programs.

SQL on DB2

Code400 - Forum

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.

Visit the Forum

A regular expression is similar to a rule which defines the characters that can appear in an expression. In SQL databases, selecting field values based on regular expressions can be very useful. One example would be to validate credit card numbers or telephone numbers from a given database field. Another would be to check numeric values matching a particular sequence, such as integers containing the digits 99 or 88. SQL server database implementations provide built-in regular expression support.

Get IP Address

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

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) JAVA 8 upgrade process

Install JAVA 7 & 8 on V7R2 in preparation of V7R3 and 9.2.2 version 7 is part of OS on V7R2 and must be installed thru: GO LICPGM Option 11 IBM JDK 8 IBM JDK 7 Download instructions from IBM

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

« Previous