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 […]
Browse:
- Home
- Admin
One Click Data View
One Click Data View Included with m-Power beginning with the September 7th, 2011 version, the One Click Data View feature allows developers to take a sneak peak at their data with the push of a single button! Prior to this feature, developers who were unfamiliar with certain tables in their environment were forced to […]
Tags: Admin, Database, Retrievals, View Table Data
Field Conversions
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 […]
Tags: Admin, Data Dictionary
Register SQL Views
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 […]
Tags: Admin, Data Dictionary, SQL, Views
Improving Database Performance
Improving Database Performance Click here to access legacy documentation for this feature For the most part, applications generated by m-Power are run and executed in a timely fashion. However, there are the odd times when end-users have to wait too long for an application to return a dataset. In the case of slow database performance, […]
Tags: Admin, Database, Performance
Create Your Own m-Power Templates
Create Your Own m-Power Templates Editor's Note: If you would like to create your own Bootstrap themed template, please contact mrc support. An m-Power template is the building block for all applications. Every application that is compiled has its specifications sent through a specific template group that automatically generates your .HTML, .JAVA, and .XML files […]
Tags: Admin, Administration, Advanced, jQuery, Templates
Probe Analysis Tool
Probe Analysis Tool m-Power ships with the Probe Analysis tool. This utility helps advanced m-Power developers and system administrators obtain a better understanding of what system resources are being utilized and how users are accessing the system. This document will outline the most useful aspects of this tool, and also explain how you can […]
Tags: Admin, Advanced, Probe Analysis, Tomcat, Utilities
Sample UDF Code
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 […]
Tags: Admin, Advanced, Data Dictionary, External Objects, Logical Fields, RPG, SQL, UDF
Understanding Runtime Application Settings
Understanding Runtime Application Settings Click here to access the legacy version of this documentation. Runtime Application Settings are instrumental in controlling how your run-time applications connect to the correct database. This configuration is data dictionary specific, meaning that it is applicable only within the data dictionary you are currently in. The configuration works in […]
Tags: Admin, Administration, Data Dictionary, Popular
Setting Up m-Power Applications to Handle Development & Production Data
Setting Up m-Power Applications to Handle Development & Production Data Click here to access the legacy version of this documentation. 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 […]
Tags: Admin, Administration, Advanced, Data Dictionary, Database, Development, Production
Search
Browse By Category
Build Process (14)Starting with m-Power (8)
Retrievals (10)
Reports (14)
Summaries (4)
Maintainers (18)
Graphs (8)
m-Power Data Explorer (4)
General (21)
Calculations (5)
Utilities (8)
m-Power Administration (20)
Security (11)
Freemarker (6)
m-Painter (27)
Form Validation (5)
External Objects & UDFs (11)
Deprecated Documentation (33)
Bootstrap Templates (7)