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 Read the rest of this document »
Browse By Category
Starting with m-Power (13)Retrievals (3)
Reports (16)
Summaries (1)
Maintainers (12)
Graphs (6)
General (24)
Calculations (5)
m-Power Administration (11)
Security (4)
Freemarker (6)
m-Painter (20)
Form Validation (5)
External Objects & UDFs (10)
Videos (15)
Popular Tags
Smartlinking Prompt Screens Calculations Oracle m-Power Email Compiling Excel Java Parameters m-Painter Dates Mobile Applications Subtotals Tomcat Admin Data Dictionary Graphs Record Selections PDF Firefox Database HTML Summaries Form Validation Getting Started Conditional Calculations MySQL DB2 Templates Application Properties SQL UDF Production Graph Properties External Objects mrc-Productivity Series Application Calculations Bar Graphs Freemarker MS SQL Maintainers Reports Retrievals DropdownsSee all tags »
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 Read the rest of this document »
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 Read the rest of this document »