mrc logo mrc logo
  • m-Power m-Power
    What is m-Power?
    Overview Demos Build Process Case Studies Specs Pricing Trial
    m-Power Resources
    Overview How-To Videos Webinars & Podcasts White Papers Fact Sheets
  • Solutions Solutions
    What does m-Power build?
    Overview Data Exploration Reporting Business Intelligence Dashboards Mobile Apps ERP Enhancements Modernization Spreadsheets to the web B2B/Web Portals Scheduling Embedded Analytics Web Forms Workflow Database Front-Ends
    Solutions by Industry
    Overview Manufacturing Government Foodservice Software Vendors Logistics & Supply Chain Software Consultants Healthcare
  • Services Services
    Overview Training Project Consulting Staff Consulting Mentoring
  • About About
    Overview Partners Press Releases Careers Events Contact Blog
  • Support Support
    Support Home FAQ Documentation Customer Portal Enhancements Updates Roadmap Techblog
Try m-Power

m-Power Manual

Browse:

  • Home
  • Data Dictionary

Interface and Build Settings

Interface and Build Settings Click here to access legacy documentation for this feature The Interface and Build Settings within m-Power allows you to control default application options and settings within your data dictionary. Most importantly, this section allows you to control the Template style (Bootstrap, Sky, or Retro) that is used in your dictionary. Please […]

Tags: Administration, Configure, Data Dictionary, Popular

Global Application Properties

Configuring Global Application Properties Click here to access legacy documentation for this feature As you may know, the majority of an application's behavior is controlled via the Application Properties file, found within each specific application. This design, while giving developers maximum control and flexibility, can sometimes frustrate developers who would like to globally control some […]

Tags: Advanced, App Properties, Application Properties, Data Dictionary, videos

Data Dictionary Reporting

Data Dictionary Reporting Data Dictionary Reports allow m-Power developers to better understand the organization and hierarchy of their Data Dictionary. Developers can utilize Data Dictionary Reports in a number of ways, including: Viewing the Dictionary Dashboard, which provides numerous key statistics. Searching for where tables, fields, external objects, and UDFs are utilized with the Data […]

Tags: Dashboard, Data Dictionary, Data Dictionary Reports, m-Power interface, m-Power Meta Data

Create a Logical Field via the Data Dictionary

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 […]

Tags: Admin, Data Dictionary, Logical Fields

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

Data Dictionary

Data Dictionary   Click here to access the legacy version of this documentation. 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 […]

Tags: Data Dictionary, Getting Started, Synonyms

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

More Results »

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)

Popular Tags

External Objects Video Tomcat Getting Started Bar Graphs UDF Graph Properties RPG Database DB2 m-Painter Graphing Compiling Popular Retrievals Graphs mrc-Productivity Series Form Validation Parameters m-Power Record Selections SQL Calculations Maintainers Application Properties Dates Retrieval Production Dropdowns Summaries Security Freemarker Report Advanced Java Admin App Properties Prompt Screens Reports Email Maintainer Bootstrap Templates Excel Administration Data Dictionary

See all tags »

michaels, ross & cole, ltd. (mrc)
Privacy Settings Privacy Policy Cookie Policy Employee Intranet
© 2018 mrc. All rights reserved.
mrc (US)

2001 Midwest Road
Suite 310
Oak Brook, IL 60523
630-916-0662

mrc (UK)

Mortlake Business Centre
20 Mortlake High Street
London, SW14 8JN
+44-20-335-59566