Dictionary Configuration The Dictionary Configuration option within m-Power allows you to control default application options and settings within your data dictionary. Most importantly, Dictionary Configuration allows you to control the Template style (Bootstrap, Sky, or Retro) that is used in your dictionary. Please note that some of the options here only apply to Bootstrap templates. […]
Browse:
- Home
- Data Dictionary
Global Application Properties
Configuring Global Application Properties 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 of these properties across all of their m-Power applications. […]
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 […]
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 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 […]
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 the Servlet Properties File for m-Power Templates
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 […]
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 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 […]
Tags: Admin, Administration, Advanced, Data Dictionary, Database, Development, Production
Search
Browse By Category
Build Process (13)Starting with m-Power (8)
Retrievals (10)
Reports (15)
Summaries (4)
Maintainers (17)
Graphs (8)
m-Power Data Explorer (4)
General (24)
Calculations (5)
Utilities (9)
m-Power Administration (23)
Security (11)
Freemarker (6)
m-Painter (29)
Form Validation (5)
External Objects & UDFs (12)
Deprecated Documentation (23)
Bootstrap Templates (7)