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
  • SQL

Sample External Object (SQL) Source Code

Sample External Object (SQL) Source Code   CREATE procedure MRCWORKLIB.DELDETAIL(  inout orderno decimal(6,0)) LANGUAGE SQL IS DETERMINISTIC MODIFIES SQL DATA BEGIN DELETE FROM MRCWORKLIB.ORDDET WHERE ORDNUM = orderno; END

Tags: External Objects, SQL

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

Register SQL Views

Register SQL Views   An SQL View can be thought of as a virtual table — one that does not physically contain any data but rather stores useful SQL queries to improve database/user efficiency. While most developers realize how powerful an SQL view can be while running queries, they can now harness the same functionality […]

Tags: Admin, Data Dictionary, SQL, Views

Validating via an SQL Procedure Source Code

Validating via an SQL Procedure Source Code   create procedure mrcworklib.validdates (inout i_error char(99),  inout i_strdate decimal(8,0),  inout i_enddate decimal(8,0)) LANGUAGE SQL CASE when i_strdate = 0 and i_enddate = 0 then    set i_error = 'You have not entered any dates.'; when i_strdate = 0 then    set i_error = 'You must enter a starting date.'; […]

Tags: External Objects, Form Validation, SQL

Validating via an SQL External Object

Validating via an SQL Procedure   This document will explain how to create and call an external object SQL procedure for validity checking. For basic information regarding validity checking please see this document. The source code for the SQL used in this example can be found here. The purpose of this object is to check […]

Tags: External Objects, Form Validation, SQL

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

Calculation Screen

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

Tags: Application Calculations, Calculations, Conditional Calculations, Database Calculations, Dates, External Objects, Parameter Calculations, SQL, System Variables

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

Utilizing Multi-Member Files in m-Power

Utilizing Multi-Member Files in m-Power   Many m-Power users believe that they are unable to utilize their multi-member files in m-Power because m-Power was designed to work over Databases other than DB2. Since these other databases do not have multi-member files, we removed the ability from the interface to access these multi-member files. However, there […]

Tags: Database, DB2, SQL

Override Default SQL Statement

Override Default SQL Statements   m-Power applications allow you to have the ability to manually override the default SQL statement. Some customers wish to do this to be able to fully customize which data is extracted from the database. To do this, build your application as you normally would. In the illustration provided below, we […]

Tags: Application Properties, SQL

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

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

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