m-Power Manual

Data Dictionary Reporting   Note: The following documentation illustrates features that were added to m-Power with the April 18th, 2012 update. If your version of m-Power does not match what is documented below, please consider taking an m-Power update. Data Dictionary Reports allow m-Power developers to better understand the organization and hierarchy of their Data Read the rest of this document »

How to Create a Logical Field via the Data Dictionary   Logical Fields are fields that do not physically exist within your databases’ tables, but rather are configured by you as a Developer. m-Power’s Data Dictionary structure allows you to define these logical fields just one time, and you are able to access them throughout Read the rest of this document »

Field Conversion   Introduction The Field Conversion feature is a powerful solution for cases when a database field is stored in one format, but that value needs to be converted to another format for display purposes. Any database field might be stored in a format different from its intended display format. In that case, the Read the rest of this document »

Register SQL Views   An SQL View can be thought of as a virtual table — one that does not physically contain any data but rather stores useful SQL queries to improve database/user efficiency. While most developers realize how powerful an SQL view can be while running queries, they can now harness the same functionality Read the rest of this document »

Data Dictionary   A Data Dictionary is a work environment for m-Power users. It contains the registered meta-data that describe the tables/fields/joins/rules needed to create applications. For each Data Dictionary, there is a corresponding server file directory containing all of the generated components for all of the applications created within that Data Dictionary. Within the Read the rest of this document »

Sample User-Defined Function (UDF) Code   Every database has its own rules for languages which may be used to write User Defined Functions (UDFs). Here are two examples, one written in SQL and another in RPG, showing how to create functions for DB2/400. Example 1: Writing a UDF with SQL We are going to build Read the rest of this document »

Data Source Configuration file for m-Power Templates   The Data Source Configuration File (also known as the mrc-spring-context.xml file) is instrumental in controlling how your run-time applications connect to the correct database. This file is a global file, meaning that it is applicable across every data dictionary on the system. This file works in conjunction Read the rest of this document »

Understanding the Servlet Properties File for m-Power Templates   The Servlet Properties File (also known as the mrc_servlet_config.xml file) is instrumental in controlling how your run-time applications connect to the correct database. This file is a data dictionary specific file, meaning that it is applicable only within the data dictionary you are currently in. This Read the rest of this document »

Setting Up m-Power Applications to Handle Development & Production Data   After developing applications, it makes good sense to promote these applications to a production environment. There are many documents that explain how to do that on this site. For example, Set up a production instance. However, this document covers something very different from just Read the rest of this document »

Built-in Menu System   Do you find yourself needing to build a Menu for all of the great generated applications you have built with m-Power? Tired of plain .html files that offer no security or Menuing Systems that you have to create all the tables by hand? mrc now offers the ability to create your Read the rest of this document »