--- title: Discover Education and Tools for IBM i Modernization at WMCPA! description: Discover Education and Tools for IBM i Modernization at WMCPA! image: https://blog.profoundlogic.com/hs-fs/file-3619154581-jpg/blog-files/wmcpa-2015-700x233.jpg --- [![(877) 224-7768 <>](https://no-cache.hubspot.com/cta/default/1708946/5d9809e1-1922-4e3e-b06b-d359616d29bd.png)](https://cta-redirect.hubspot.com/cta/redirect/1708946/5d9809e1-1922-4e3e-b06b-d359616d29bd) [![sales@profoundlogic.com ](https://no-cache.hubspot.com/cta/default/1708946/4fc30eb7-f66d-4552-81e2-49cc209a5ead.png)](https://cta-redirect.hubspot.com/cta/redirect/1708946/4fc30eb7-f66d-4552-81e2-49cc209a5ead) [![Share on facebook](https://7528309.fs1.hubspotusercontent-na1.net/hub/7528309/hubfs/raw_assets/public/mV0_d-web-default-modules_hubspot/img/facebook-color.png?width=24&name=facebook-color.png)](https://www.facebook.com/share.php?u=https%3A%2F%2Fblog.profoundlogic.com%2Fdiscover-education-tools-ibm-modernization-wmcpa%2F%3Futm_medium%3Dsocial%26utm_source%3Dfacebook) [![Share on twitter](https://7528304.fs1.hubspotusercontent-na1.net/hub/7528304/hubfs/raw_assets/public/mV0_d-web-default-modules_hubspot/img/twitter-color.png?width=24&name=twitter-color.png)](https://twitter.com/intent/tweet?original_referer=https%3A%2F%2Fblog.profoundlogic.com%2Fdiscover-education-tools-ibm-modernization-wmcpa%2F%3Futm_medium%3Dsocial%26utm_source%3Dtwitter&url=https%3A%2F%2Fblog.profoundlogic.com%2Fdiscover-education-tools-ibm-modernization-wmcpa%2F%3Futm_medium%3Dsocial%26utm_source%3Dtwitter&source=tweetbutton&text=) [![Profound Logic](https://blog.profoundlogic.com/hs-fs/hubfs/PLS_Logo.jpg?width=150&height=52&name=PLS_Logo.jpg "Profound Logic")](https://www.profoundlogic.com/) - AI-Enhanced Products - [Profound AI](https://www.profoundlogic.com/ai/) - [Profound UI](https://www.profoundlogic.com/profoundui/) - [Profound.js](https://www.profoundlogic.com/profoundjs/) - [Profound API](https://www.profoundlogic.com/api/) - Services - Futurization and Transformation - [Profound 360 Analysis](https://www.profoundlogic.com/services/profound-360-analysis/) - [Flexible IBM i Code Transformation](https://www.profoundlogic.com/services/flexible-code-transformation/) - [IBM i UX Modernization Service](https://www.profoundlogic.com/services/ibm-i-ux-modernization-service/) - [Database Modernization](https://www.profoundlogic.com/services/database-modernization/) - Integration & API Development - [System Integration](https://www.profoundlogic.com/services/systems-integration/) - [Cloud Migration Services](https://www.profoundlogic.com/services/cloud-migration-services/) - [Rapid Application Development](https://www.profoundlogic.com/services/application-development/) - [Application Development](https://www.profoundlogic.com/services/application-development/) - [Mobile Application Development](https://www.profoundlogic.com/services/mobile-application-development/) - [Company](https://www.profoundlogic.com/about-profound-logic/) - [About Us](https://www.profoundlogic.com/about-profound-logic/) - [Press Releases](https://www.profoundlogic.com/press-releases/) - [Careers](https://www.profoundlogic.com/careers/) - [Contact Us](https://www.profoundlogic.com/contact/) - Resources - [Blog](https://www.profoundlogic.com/blog/) - [Case Studies](https://www.profoundlogic.com/case-studies/) - [On-Demand Webinars](https://www.profoundlogic.com/webinars/) - [White Papers](https://www.profoundlogic.com/white-papers/) - [Product Documentation](https://profoundlogicsupport.atlassian.net/wiki/spaces/PUI/overview) - [User Forum](https://forum.profoundlogic.com/) - [Contact Support](https://profoundlogicsupport.atlassian.net/servicedesk/customer/portal/1) [![Contact Us](https://no-cache.hubspot.com/cta/default/1708946/interactive-172756632938.png)](https://blog.profoundlogic.com/hs/cta/wi/redirect?encryptedPayload=AVxigLKE53FuRqSgZMfK6OPjiRMWNWadjFnWRnyzKFRxsWNvQ4Rd9ICmw8LYLGHjX%2FwOpUnSHgzvaRWF1D4MH1FMw6JPg1zx%2Fj9cxc5SUOJLsxe7u8id02xS9ShV9nNXXmYVXFBL3XdPxZst4iWX6wac2d%2FhectOCF63qLokbnzZ8plQ79vLfLS9ANvU&webInteractiveContentId=172756632938&portalId=1708946) # iModernize - The Profound Logic Software Blog # Discover Education and Tools for IBM i Modernization at WMCPA! Posted by [Profound Logic](https://blog.profoundlogic.com/author/profound-logic) on Mar 5, 2015 4:40:45 AM - [Tweet](https://twitter.com/share) [![WMCPA Conference 2015 IBM i Profound Logic Software](https://blog.profoundlogic.com/hs-fs/file-3619154581-jpg/blog-files/wmcpa-2015-700x233.jpg?width=700&height=233&name=wmcpa-2015-700x233.jpg)](https://blog.profoundlogic.com/hs-fs/file-3619154581-jpg/blog-files/wmcpa-2015-700x233.jpg) Attending the [Wisconsin Midrange Computer Professional Association's (WMCPA) Spring Technical Conference](http://www.wmcpa.org/index.php/conference-2015) next week? Don't miss the chance to learn tips for successful RPG, database and application development and modernization with sessions by **Profound Logic Developer and IBM i Champion Scott Klement.** You can also learn more about RPG and DB modernization with a hands-on lab led by Jeff Tickner from our partner ARCAD Software. Make sure to stop by the Profound Logic and Arcad Software booths to discover how our partnership offers the most comprehensive, integrated and pro-IBM i solution for modernizing your enterprise development environment. (Watch our [recent joint Webinar](http://www.profoundlogic.com/resourcesPages/webcast-reach-your-ibm-i-modernization-goals-with-arcad-and-profound-logic-software.html) for more information about that partnership!) - A complete session schedule is here: [http://www.wmcpa.org/index.php/conference-2015](http://www.wmcpa.org/index.php/conference-2015) - Descriptions of Scott's sessions are here: [http://www.wmcpa.org/index.php/scott-klement](http://www.wmcpa.org/index.php/scott-klement) - You can learn more about Arcad's modernization labs here: [http://www.wmcpa.org/index.php/jeff-tickner](http://www.wmcpa.org/index.php/jeff-tickner) # Session Schedule: ## Wednesday, March 11, 2015 **RPG User Defined Functions & Table Functions** Speaker: Scott Klement 10:15a-11:45a, Geneva 1 RPG is the best language in the world for writing business rules. But what happens when you want to use those business rules from SQL? Or from a web application that accesses your business logic through SQL? In this session, Scott will explain how User Defined Functions (UDFs) can be called from SQL statements to run from anywhere, including ad-hoc queries, SQL run from web applications, and SQL run from the embedded SQL precompilers used by RPG and other languages. **Hands-on Lab: Mobile App in RPG with Profound UI** Speaker: Scott Klement 2:30p-4:00p, Courtyard 2 This hands-on lab will give you the chance to try creating a mobile app using [Profound UI](http://www.profoundlogic.com/products/profound-ui-modernization-suite-for-ibm-i-applications.html). With this tool, you can write an RPG program that runs on IBM i, and when it does a standard EXFMT operation, the display will come up on a mobile device. It is the easiest and most powerful way to create mobile apps on IBM i. **Hands-on Lab: Modernize your Database with ARCADTransformer DB** Speaker: Jeff Tickner 10:15a-11:45a, Courtyard 3 **Hands-on Lab: Modernize your Code with ARCADTransformer RPG** Speaker: Jeff Tickner 2:30p-4:00p, Courtyard 3 "The Mini Modernization Lab", This lab will offer some hands on experience to understand the challenges of Modernization. No matter where you starting point the lab will allow for discussion with experts in many areas of the Modernization movement. In addition, IBM and Arcad Software solutions will be available to facilitate the conversion of fixed format RPG to free form and the conversion of DDS to DDL. Bring your unique challenges to the lab to learn firsthand recommended best practices. ## Thursday, March 12, 2015 **Accessing External Databases from RPG** Speaker: Scott Klement 10:15a-11:45a, Geneva 1 Years ago, a business might have run everything on one platform, but not today. RPGers often need to access data from 3rd party databases, such as Microsoft SQL Server, Oracle, MySQL and DB2 on other platforms. One way to do this is by using Java database (JDBC) drivers in your RPG programs. Scott will share his experience in using this technique and show you how you can access external databases from your RPG programs.   Topics: [Events & Education](https://blog.profoundlogic.com/topic/events-education), [Partnerships](https://blog.profoundlogic.com/topic/partnerships) Search Blog ### Subscribe to Blog Updates **....and get our "How to Get Full Business Buy-In for Your Modernization Project" ebook!** ![business buy-in ebook](https://blog.profoundlogic.com/hs-fs/hubfs/mockup.png?width=621&name=mockup.png "business buy-in ebook") ### Recent Posts ### Posts by Topic - [Events & Education (203)](https://blog.profoundlogic.com/topic/events-education) - [Application modernization (173)](https://blog.profoundlogic.com/topic/application-modernization) - [IBM i Modernization (169)](https://blog.profoundlogic.com/topic/ibm-i-modernization) - [IBM i applications (169)](https://blog.profoundlogic.com/topic/ibm-i-applications) - [Profound.js (165)](https://blog.profoundlogic.com/topic/profound-js) - [Node.js (164)](https://blog.profoundlogic.com/topic/node-js) - [Agile modernization (162)](https://blog.profoundlogic.com/topic/agile-modernization) - [IBM i (161)](https://blog.profoundlogic.com/topic/ibm-i) - [RPG (158)](https://blog.profoundlogic.com/topic/rpg) - [AS400 modernization (157)](https://blog.profoundlogic.com/topic/as400-modernization) - [iSeries (149)](https://blog.profoundlogic.com/topic/iseries) - [Legacy Modernization (141)](https://blog.profoundlogic.com/topic/legacy-modernization) - [RPG Development (85)](https://blog.profoundlogic.com/topic/rpg-development) - [AS 400 (58)](https://blog.profoundlogic.com/topic/as-400) - [Profound UI (54)](https://blog.profoundlogic.com/topic/profound-ui) - [Profound Logic (50)](https://blog.profoundlogic.com/topic/profound-logic) - [AS\_400 (49)](https://blog.profoundlogic.com/topic/as_400) - [New Features (28)](https://blog.profoundlogic.com/topic/new-features) - [Tips and Tricks (26)](https://blog.profoundlogic.com/topic/tips-and-tricks) - [Development (20)](https://blog.profoundlogic.com/topic/development) - [green screen modernization (15)](https://blog.profoundlogic.com/topic/green-screen-modernization) - [Mobile Development (14)](https://blog.profoundlogic.com/topic/mobile-development-2) - [5250 (12)](https://blog.profoundlogic.com/topic/5250) - [IBM Watson (10)](https://blog.profoundlogic.com/topic/ibm-watson) - [Press Release (9)](https://blog.profoundlogic.com/topic/press-release) - [Product Announcement (9)](https://blog.profoundlogic.com/topic/product-announcement) - [Scott Klement Health (7)](https://blog.profoundlogic.com/topic/scott-klement-health) - [Partnerships (6)](https://blog.profoundlogic.com/topic/partnerships) - [PLUS 2018 (5)](https://blog.profoundlogic.com/topic/plus-2018) - [Prime UI (5)](https://blog.profoundlogic.com/topic/prime-ui) - [Case Study (4)](https://blog.profoundlogic.com/topic/case-study) - [Enterprise Modernization (3)](https://blog.profoundlogic.com/topic/enterprise-modernization) - [Year in review (3)](https://blog.profoundlogic.com/topic/year-in-review) - [PLUS 2019 (2)](https://blog.profoundlogic.com/topic/plus-2019) - [mobile applications (2)](https://blog.profoundlogic.com/topic/mobile-applications) - [mobile mondernization (2)](https://blog.profoundlogic.com/topic/mobile-mondernization) - [2016 Survey (1)](https://blog.profoundlogic.com/topic/2016-survey) - [2019 Survey (1)](https://blog.profoundlogic.com/topic/2019-survey) - [Conversion Service (1)](https://blog.profoundlogic.com/topic/conversion-service) - [Model 3 (1)](https://blog.profoundlogic.com/topic/model-3) - [Tesla (1)](https://blog.profoundlogic.com/topic/tesla) - [connectria (1)](https://blog.profoundlogic.com/topic/connectria) - [node (1)](https://blog.profoundlogic.com/topic/node) see all ### Archive - [September 2014 (17)](https://blog.profoundlogic.com/archive/2014/09) - [March 2017 (14)](https://blog.profoundlogic.com/archive/2017/03) - [May 2017 (10)](https://blog.profoundlogic.com/archive/2017/05) - [April 2019 (10)](https://blog.profoundlogic.com/archive/2019/04) - [May 2019 (10)](https://blog.profoundlogic.com/archive/2019/05) - [February 2013 (9)](https://blog.profoundlogic.com/archive/2013/02) - [June 2017 (9)](https://blog.profoundlogic.com/archive/2017/06) - [August 2017 (9)](https://blog.profoundlogic.com/archive/2017/08) - [September 2017 (9)](https://blog.profoundlogic.com/archive/2017/09) - [October 2017 (9)](https://blog.profoundlogic.com/archive/2017/10) - [July 2017 (8)](https://blog.profoundlogic.com/archive/2017/07) - [June 2018 (8)](https://blog.profoundlogic.com/archive/2018/06) - [January 2019 (8)](https://blog.profoundlogic.com/archive/2019/01) - [March 2019 (8)](https://blog.profoundlogic.com/archive/2019/03) - [June 2019 (8)](https://blog.profoundlogic.com/archive/2019/06) - [August 2014 (7)](https://blog.profoundlogic.com/archive/2014/08) - [August 2015 (7)](https://blog.profoundlogic.com/archive/2015/08) - [December 2017 (7)](https://blog.profoundlogic.com/archive/2017/12) - [January 2018 (7)](https://blog.profoundlogic.com/archive/2018/01) - [July 2018 (7)](https://blog.profoundlogic.com/archive/2018/07) - [August 2018 (7)](https://blog.profoundlogic.com/archive/2018/08) - [October 2018 (7)](https://blog.profoundlogic.com/archive/2018/10) - [June 2014 (6)](https://blog.profoundlogic.com/archive/2014/06) - [October 2014 (6)](https://blog.profoundlogic.com/archive/2014/10) - [September 2015 (6)](https://blog.profoundlogic.com/archive/2015/09) - [April 2017 (6)](https://blog.profoundlogic.com/archive/2017/04) - [November 2017 (6)](https://blog.profoundlogic.com/archive/2017/11) - [March 2018 (6)](https://blog.profoundlogic.com/archive/2018/03) - [November 2018 (6)](https://blog.profoundlogic.com/archive/2018/11) - [December 2018 (6)](https://blog.profoundlogic.com/archive/2018/12) - [February 2019 (6)](https://blog.profoundlogic.com/archive/2019/02) - [January 2014 (5)](https://blog.profoundlogic.com/archive/2014/01) - [April 2014 (5)](https://blog.profoundlogic.com/archive/2014/04) - [October 2015 (5)](https://blog.profoundlogic.com/archive/2015/10) - [February 2018 (5)](https://blog.profoundlogic.com/archive/2018/02) - [April 2018 (5)](https://blog.profoundlogic.com/archive/2018/04) - [July 2020 (5)](https://blog.profoundlogic.com/archive/2020/07) - [January 2013 (4)](https://blog.profoundlogic.com/archive/2013/01) - [March 2013 (4)](https://blog.profoundlogic.com/archive/2013/03) - [April 2013 (4)](https://blog.profoundlogic.com/archive/2013/04) - [July 2014 (4)](https://blog.profoundlogic.com/archive/2014/07) - [May 2018 (4)](https://blog.profoundlogic.com/archive/2018/05) - [September 2018 (4)](https://blog.profoundlogic.com/archive/2018/09) - [July 2019 (4)](https://blog.profoundlogic.com/archive/2019/07) - [September 2013 (3)](https://blog.profoundlogic.com/archive/2013/09) - [March 2014 (3)](https://blog.profoundlogic.com/archive/2014/03) - [July 2015 (3)](https://blog.profoundlogic.com/archive/2015/07) - [November 2015 (3)](https://blog.profoundlogic.com/archive/2015/11) - [January 2016 (3)](https://blog.profoundlogic.com/archive/2016/01) - [March 2016 (3)](https://blog.profoundlogic.com/archive/2016/03) - [April 2016 (3)](https://blog.profoundlogic.com/archive/2016/04) - [September 2016 (3)](https://blog.profoundlogic.com/archive/2016/09) - [October 2019 (3)](https://blog.profoundlogic.com/archive/2019/10) - [June 2020 (3)](https://blog.profoundlogic.com/archive/2020/06) - [August 2020 (3)](https://blog.profoundlogic.com/archive/2020/08) - [November 2013 (2)](https://blog.profoundlogic.com/archive/2013/11) - [February 2014 (2)](https://blog.profoundlogic.com/archive/2014/02) - [May 2014 (2)](https://blog.profoundlogic.com/archive/2014/05) - [November 2014 (2)](https://blog.profoundlogic.com/archive/2014/11) - [January 2015 (2)](https://blog.profoundlogic.com/archive/2015/01) - [April 2015 (2)](https://blog.profoundlogic.com/archive/2015/04) - [February 2016 (2)](https://blog.profoundlogic.com/archive/2016/02) - [June 2016 (2)](https://blog.profoundlogic.com/archive/2016/06) - [July 2016 (2)](https://blog.profoundlogic.com/archive/2016/07) - [October 2016 (2)](https://blog.profoundlogic.com/archive/2016/10) - [December 2016 (2)](https://blog.profoundlogic.com/archive/2016/12) - [February 2017 (2)](https://blog.profoundlogic.com/archive/2017/02) - [March 2020 (2)](https://blog.profoundlogic.com/archive/2020/03) - [April 2020 (2)](https://blog.profoundlogic.com/archive/2020/04) - [May 2020 (2)](https://blog.profoundlogic.com/archive/2020/05) - [September 2020 (2)](https://blog.profoundlogic.com/archive/2020/09) - [October 2020 (2)](https://blog.profoundlogic.com/archive/2020/10) - [January 2021 (2)](https://blog.profoundlogic.com/archive/2021/01) - [November 2012 (1)](https://blog.profoundlogic.com/archive/2012/11) - [December 2012 (1)](https://blog.profoundlogic.com/archive/2012/12) - [May 2013 (1)](https://blog.profoundlogic.com/archive/2013/05) - [June 2013 (1)](https://blog.profoundlogic.com/archive/2013/06) - [July 2013 (1)](https://blog.profoundlogic.com/archive/2013/07) - [August 2013 (1)](https://blog.profoundlogic.com/archive/2013/08) - [October 2013 (1)](https://blog.profoundlogic.com/archive/2013/10) - [December 2013 (1)](https://blog.profoundlogic.com/archive/2013/12) - [December 2014 (1)](https://blog.profoundlogic.com/archive/2014/12) - [March 2015 (1)](https://blog.profoundlogic.com/archive/2015/03) - [May 2015 (1)](https://blog.profoundlogic.com/archive/2015/05) - [May 2016 (1)](https://blog.profoundlogic.com/archive/2016/05) - [November 2016 (1)](https://blog.profoundlogic.com/archive/2016/11) - [January 2017 (1)](https://blog.profoundlogic.com/archive/2017/01) - [August 2019 (1)](https://blog.profoundlogic.com/archive/2019/08) - [December 2019 (1)](https://blog.profoundlogic.com/archive/2019/12) - [November 2020 (1)](https://blog.profoundlogic.com/archive/2020/11) - [December 2020 (1)](https://blog.profoundlogic.com/archive/2020/12) see all #### Related Resources - [\[fa icon="caret-right"\] Benefits of Modernizing Legacy Systems](https://www.profoundlogic.com/benefits-of-modernizing-legacy-systems/) - [\[fa icon="caret-right"\] Customer Satisfaction and Supply Chains](https://www.profoundlogic.com/customer-satisfaction-and-supply-chains/) - [\[fa icon="caret-right"\] Why Your Business Must Modernize Its Legacy Applications](https://www.profoundlogic.com/why-your-business-must-modernize-its-legacy-applications/) - \[fa icon="caret-right"\] Coding in 2021 and Beyond: Is Node.js Dead? #### Recommended for you - [\[fa icon="caret-right"\] The Importance of API Security to Protect Sensitive Business Data](https://info.profoundlogic.com/the-importance-of-api-security-to-protect-sensitive-business-data) - [\[fa icon="caret-right"\] Why API Matters for Enterprise Development](https://info.profoundlogic.com/why-api-matters-for-business-development-whitepaper) - [\[fa icon="caret-right"\] The Cost of Technical Debt to Business on IBM i](https://info.profoundlogic.com/technical-debt) - [\[fa icon="caret-right"\] Node.js for Enterprise IBM i Modernization](https://info.profoundlogic.com/node) #### Watch now on demand - [\[fa icon="caret-right"\] What is Code Transformation?](https://info.profoundlogic.com/code-transformation-stage-one) - [\[fa icon="caret-right"\] Transform IBM i/AS400 Now](https://www.profoundlogic.com/transform-ibm-i-as400-now/) - [\[fa icon="caret-right"\] Profound API, Low-Code and Product Updates Announced at PLUS 2020](https://info.profoundlogic.com/plus2020) - [\[fa icon="caret-right"\] IBM i Transformation Risks Every Business Leader Should Know](https://info.profoundlogic.com/transformation-risks-wod) #### Company - [\[fa icon="caret-right"\] About Us](https://www.profoundlogic.com/about-profound-logic/) - [\[fa icon="caret-right"\] Press Releases](https://www.profoundlogic.com/press-releases/) - [\[fa icon="caret-right"\] Events and Webinars](https://www.profoundlogic.com/events/) - [\[fa icon="caret-right"\] Careers](https://www.profoundlogic.com/careers/) - [\[fa icon="caret-right"\] Partnerships](https://www.profoundlogic.com/partnerships/) - [\[fa icon="caret-right"\] Contact Us](https://www.profoundlogic.com/contact/) [Sign up for our newsletter](https://www.profoundlogic.com/newsletter-signup-profound-logic/) | [Developers](https://docs.profoundlogic.com/) | [Blog](https://www.profoundlogic.com/blog/) | [Privacy](https://www.profoundlogic.com/privacy-policy) | [Contact](https://www.profoundlogic.com/contact/) | [1-877-224-7768](tel:877-224-7768) Copyright © 2026 Profound Logic Software | [Sitemap](https://www.profoundlogic.com/sitemap.xml) \[fa icon="chevron-up"\] ![](https://www.facebook.com/tr?id=237478240316292&ev=PageView&noscript=1)