Loading…
Attending this event?
Experience the magic of education. 
View analytic
Sunday, May 19 • 10:15am - 11:15am
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

Speakers
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, SQL functions and the SQL descriptor. I would love to talk to you about... Read More →


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

Twitter Feed