Database

Embedded m-Power Database

Embedded m-Power Database m-Power ships with the ability to configure an embedded m-Power database. The purpose of the embedded database is to conveniently store all m-Power related meta-data outside of your licensed database. m-Power meta-data consists of all of the specifications you make (sequencing, record selection, registered fields, synonyms, etc..) while creating m-Power applications. The […]

Data Source Configuration file for m-Power

Data Source Configuration file for m-Power Templates The Data Source Configuration option allows developers to control how their┬árun-time applications connect to the back-end database. This file is a global file, meaning that it is applicable across every data dictionary on the system. This file works in conjunction with its sister file, the Servlet Properties file. […]

m-Power System Requirements

m-Power System Requirements   Prior to installing m-Power, please be sure that the following requirements have been met. *64-bit servers are highly recommended as they support more RAM than 32-bit servers.* m-Power End-User Client Requirements Web Browser Microsoft Internet Explorer Internet Explorer 11 or later Firefox Firefox Version 40.0 or later Chrome Chrome Version 40.0 […]

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

Improving Database Performance

Improving Database Performance   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, an index can be created to significantly speed […]

Basic Database and m-Power Terms

Basic Database and m-Power Terms   Please review the following database and m-Power terms: Database Terms Database A collection of stored data in a structured format. A Data Dictionary is a collection of tables and fields and the applications you build over them. It is your m-Power work environment. Table A set of data values […]

Performance Considerations

Performance Considerations   Jump to: How to Build an Index Retrievals Basic Example Advanced Example Reports Standard Report Templates with Detail Interactive Report Template & Creating Dropdown Lists from the Current Application Standard Report Templates with No Detail / Interactive Report Template Working with Runtime Record Selections Summaries Maintenance Other Things to Consider This document […]

Local Database Connections with V6R1

Local Database Connections with V6R1   Both m-Power and mrc-Productivity Series customers have the ability to utilize a Local Database Connection if running their software off of an AS400. m-Power customers can see this connection by going to Data Dictionary –> Edit Data Dictionary Files –> Data Source Configuration. Classic Servlet customers can see this […]

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

Change Variable Data Sources

Change Variable Data Source   The data source is the definition of the database connection which includes: IP address DB type DB driver name User and password Special considerations, such as the library list Multiple data sources can be defined in the global Data Source Configuration file (/mrcjava/WEB-INF/classes/mrc-spring-context.xml). In each dictionary (/mrcjava/WEB-INF/classes/DD/mrc_servlet_config.xml), you can assign […]