POWERUp 2019 has ended
Experience the magic of education. 
Back To Schedule
Sunday, May 19 • 10:15am - 11:15am
13BP Creating SQL Functions

Log in to save this to your schedule, view media, leave feedback and see who's attending!

If you use SQL, then you already use built in functions such as SUM, COUNT and UPPER to transform data. By creating your own functions, you can execute complex code written in any host based language. This allows you to very easily reuse already tested business logic. This seminar will teach you what you need to know in order to create your own SQL functions.

Learning Objectives:

  1. Built in functions 
  2. Anatomy of a function 
  3. Steps required to build a function
  4. Creating and dropping functions
  5. Unpacking the create function statement

avatar for Greg Cannella

Greg Cannella

Director of MIS, Magid Glove & Safety Mfg
I have a new found passion for creating tools in PHP. I have developed a dashboard tool that allows users to access data on the IBM-I using SQL and display the data in a web browser. I did this using PHP, SQL, and SQL functions. I would love to talk to you about any of these topics... Read More →

Sunday May 19, 2019 10:15am - 11:15am PDT
Fantasy Tower Magic Kingdom 4