Calling a Sample External Object (SQL) This document will explain how to create, register, and call a sample External Object written in SQL. Recall from basic training that the purpose of an External Object is to call your back-end business logic directly through an m-Power web application. In this case, the purpose of this […]
Sample External Object (Java)
Calling a Sample External Object (Java) This document will explain how to create, register, and call a sample External Object written in Java. Recall from basic training that the purpose of an External Object is to call your back-end business logic directly through an m-Power web application. In this case, the purpose of this […]
Tags: Advanced, External Objects, Java, Maintainers
Create Your Own m-Power Templates
Create Your Own m-Power Templates Jump to: Deciding to Make a New m-Power Template Testing your Template Registering Templates to m-Power Understanding m-Power Templates Creating the Template Tips and Suggestions for Success Dealing with Run-Time Files Creating a Template Image Packaging your Template Moving to Production Publishing your Template Other Important Notes Deciding to […]
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
SmartLinks
SmartLinks Click here to view current documentation about this feature. SmartLinks allow you to easily link one application (Retrieval, Report, or Maintenance) to any other application, passing key data automatically. The benefits of this are many, including: You can create applications that allow users to drill from an order header table to order details records. […]
Tags: Advanced, Build Process, Drilldowns, Smartlinking
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 […]
Tags: Administration, Advanced, Database, DB2, Indexes, MS SQL, MySQL, Oracle, Performance, SQL
Utilizing Prompt Maintainers
Using Prompt Maintainers within a Retrieval The purpose of this document is to explain the process needed to have a user interface in which end-users enter a value on a Prompt page, then are redirected to a retrieval. The retrieval shows them the appropriate information based on the data entered from the Prompt. To […]
Add Google Maps to your Applications
Add Google Maps to your Applications Some common purposes of the Google Maps are: Map a list of available products and where your customer base may find them Visualize the location of your nationwide fleet Embed closed order addresses to determine shipping logistics Map a list of current clients to see what geographical […]
mrc Date Conversion UDFs
mrc Date Conversion UDFs (User-Defined Functions) mrc supplies three date conversion routines specifically for AS/400 databases. These routines are SQL functions located in MRCAPPLLIB, and they are available for use in logical and calculated fields. All three UDFs take a numeric date as an input parameter. Function specifications are described below. UDF Name Description […]
Tags: Advanced, Dates, External Objects, UDF
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
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)