Session 1 - RPG User-defined Functions (UDFs) & Table Functions (UDTFs) 

                            Session 2 - Setting Up and Scripting the OpenSSH, SFTP, and SCP Utilities



Speaker:  Scott Klement




Date: Tuesday, May 17, 2011



5:00 PM - Dinner and Networking with Your Peers

6:00 PM - RPG User-defined Functions (UDFs) & Table Functions (UDTFs) - Webcast 

7:30 PM - Setting Up and Scripting the OpenSSH, SFTP, and SCP Utilities - Webcast


Go to Scott's website to access handouts:  Handouts

If you will be joining us at the IBM offices, please make a reservation now so we can plan seating and dinner: Reservations


RPG User-defined Functions (UDFs) & Table Functions (UDTFs)

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? DB2 for i lets you write User Defined Functions (UDFs) in high level languages like RPG. UDFs can be called from SQL statements 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.



UDFs can even return a table (often called a UDTF, User Defined Table Function) which lets them do the same sort of work that a stored procedure would do -- but unlike stored procedures, they can return result sets to any language, including PHP, Java, .NET and embedded SQL written in ILE RPG.

UDFs are a powerful tool for any programmer's toolbox.


Learning Objectives:
1. The Concept of SQL Routines


2. How to write an external UDF in RPG

3. How to write an external UDTF in RPG


All experienced RPG programmers.


PHP, Java or SQL programmers who'd like to reuse existing RPG code.


Setting Up and Scripting the OpenSSH, SFTP, and SCP Utilities
It seems like everyone today is using the FTP protocol to send files.  One problem:  It's not very secure!

For security's sake, a lot of companies need to use SSH tools, including SSH itself, as well as the SCP and SFTP utilities.  IBM provides the OpenSSH software to IBM i customers free of charge, but it runs in the PASE environment.

If you're not familiar with Unix, how do you set up OpenSSH?  How do you use it?  How can your RPG or CL programs run SFTP scripts?  This session will tell you how.


Learning Objectives:
1. Setting up OpenSSH on i

2. The OpenSSH tools, SSH, SFTP and SCP.  What are they good for?  How do you use them?

3. How do you write programs/scripts in native languages that use the SSH tools?


Programmers that need to transfer files securely with the the SSH tools.


About the speaker:

Scott Klement is the I.T. Manager and Senior Programmer at Klement Sausage Co, Inc. He is also a technical editor for System iNEWS magazine (formerly known as NEWS/400) as well as the editor of the popular System iNetwork Programming Tips e-newsletter. His efforts to help RPG programmers improve their skills have earned Scott an iSeries Innovation Award (presented IBM and COMMON), two Gary Guthrie Awards for Excellence in Technical Writing by the staff of System iNEWS magazine, two medals from the American Society of Business Publication Editors (ASBPE), and silver and bronze medals in COMMON's Speaker Excellence hall of fame. Scott lives with his wife and son in Milwaukee, WI.


Meeting will take place at:

IBM Offices

600 Anton Blvd.

Plaza Tower Bldg. - Second Floor

Costa Mesa, CA 92626