Calculation Screen Calculation Features Calculation Types Creating Calculations Calculation Features Calculations as Sequence keys and Record Selection fields — Calculations have been designed to take full advantage of SQL. Nearly every calculation is available to use as a sequence field or record selection field. Sequence/Record Selection Availability — The Work-with Calculation screen shows which calculations […]
Browse:
- Home
- External Objects
- Page 3
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
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
Validating via an RPG External Object
Validating via an RPG External Object This document will explain how to call an external object RPG program for validity checking. For basic information regarding validity checking please see this document. The source code for this RPG can be found here. For the sake of this documentation, the RPG code will be located in […]
Tags: External Objects, Form Validation, Popular, RPG
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)