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 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
HTML Email Production Conditional Calculations Getting Started Database m-Painter Graphs mrc-Productivity Series Tomcat MS SQL Mobile Applications Firefox SQL Application Properties Form Validation m-Power Freemarker Oracle DB2 PDF Templates Summaries External Objects Java Compiling Admin Dropdowns Parameters Maintainers Retrievals Smartlinking MySQL Dates Bar Graphs Data Dictionary Excel Calculations Prompt Screens Record Selections Application Calculations Reports Graph Properties UDF SubtotalsSee all tags »
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 Read the rest of this document »
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 »