SQL – Code400

Regular Expressions

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

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

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

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

create XML from RPG read as EXCEL

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

Working examples of API’s

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

Using SQL to retrieve system information

List system values that contain “SEC” in the name. Take some time and play with the SQL — Become famous Post new samples!!! SELECT SYSTEM_VALUE_NAME as sysvalue, ifnull(CURRENT_NUMERIC_VALUE,0) as DecValue, CURRENT_CHARACTER_VALUE as CharValue FROM SYSTEM_VALUE_INFO where SYSTEM_VALUE_NAME LIKE ‘%SEC%’ this