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 Database Front-Ends Reporting CRM Systems Business Intelligence Dashboards Mobile Apps ERP Enhancements Modernization Spreadsheets to the web MS Access to the web B2B/Web Portals Scheduling Embedded Analytics Web Forms Workflow Data Exploration Budgeting & Forecasting APIs and Web Services
    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
  • External Objects & UDFs
Back to Manual

External Object Locations

External Object Template Locations   Servlet Retrievals: *CALCOBJ Used with calculation External Objects or Constant calculations. *STRADVSCH Before searching change advanced field values. Convert value for search input then process filter. *ADVRECSEC Row Level Security. Click here for additional information. *READRECRD Call object after each record is processed. *SELECTFLT Used with External drop down lists. […]

Tags: External Objects, Maintainers, Reports, Retrievals, Summaries

Return Data External Object

Return Data External Object   Beginning with the May 2013 update of m-Power, developers will have access to a Return Data Java external object for use within maintenance applications. This object takes in 1 parameter to find a row within a retrieval, and then returns that value(s) to your maintainer. A common example of using […]

Tags: Email, External Objects, Maintainers, Popular

Regular Expression External Object

Regular Expression External Object   Beginning with the May 2013 release of m-Power, developers will be able to use a Regular Expression Java external object for parsing field values. The most common example of when this would be done is with the Email Upload template, in order to grab a piece of data from one […]

Tags: External Objects, Popular

Business Rules Designer

Business Rules Designer   Overview The Business Rules Designer allows developers to create their own custom business processes, directly in m-Power, without any coding. These business rules can be invoked on a per row basis (such as returning a result for every record in a report), per action (such as calling logic when a user […]

Tags: External Objects, Popular

Sample External Object (SQL)

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

Tags: Advanced, External Objects, Maintainers, SQL

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

Sample External Object (RPG)

Calling a Sample External Object (RPG)   This document will explain how to create, register, and call a sample External Object written in RPG. 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, Maintainers, RPG

Introduction to User Defined Functions (UDF)

UDF Introduction   All applications created with m-Power employ SQL to access the database. SQL, by itself, is a very powerful language. A database User Defined Function (UDF) allows users to extend the power of SQL. UDF's are a powerful yet simple way to perform routine data transformations, calculations, and complex SQL logic. Database vendors […]

Tags: Dates, Logical Fields, UDF

Create and Register a UDF

Create and Register a User Defined Function (UDF)   A user defined function (UDF) allows users to extend the power of SQL. Like built-in database functions, UDFs are invoked from SQL statements. They can be a powerful yet simple way to perform routine data transformations, calculations, and complex SQL logic. Database vendors have specific requirements […]

Tags: UDF

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

Java Date Translator

Java Date Translator (External Object) **NOTE: This Functionality Has Been Deprecated. Please use this link to see alternative features: https://www.mrc-productivity.com/legacy/external-objects-udf/mrc-date-conversion-udfs   mrc supplies a date translator specifically for use with generated Web/Servlet applications. This Java class is named mrc.servlet.MrcDateTranslator and resides in mrcextobj.jar. The object definition is shown below. If this object definition is not […]

Tags: Calculations, Dates, Java, Java Date Translator

Created: February 29, 2008 | Modified: December 22, 2011

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)

Popular Tags

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

See all tags »

michaels, ross & cole, ltd. (mrc)
Privacy Settings Privacy Policy Cookie Policy Employee Intranet
© 2023 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