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

Log in to save this to your schedule 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
Fantasy Tower Magic Kingdom 4

Twitter Feed