BUILT-IN Functions - I didn't know Db2 could do THAT!

Date: 
Tuesday, 10 April, 2018 - 15:00 - 16:00
Speaker: 
Steve Thomas

Were you aware than Db2 for z/OS now supports more than twice as many SQL BUILT-IN functions as it did 20 years ago? The World has moved on significantly from the basic Functions such as SUM, COUNT and AVG which were all that were available when many of us first learnt SQL. There are now well over 200 Functions supported providing a huge range of powerful features. As well as the basic data manipulation and Mathematical Functions you would expect there are advanced analytical capabilities, sophisticated array management and aggregation features, XML, Security and more, all provided out of the box. Unfortunately many users have not kept up to date with advances and we find Programmers still coding requirements manually in whatever language they are using when the Database itself could be doing much more of the heavy lifting. This session will review the current capabilities of the native BUILT-IN functions provided by Db2 for z/OS and will highlight some of the more useful ones. It will be valuable whether you’re a new Application Programmer or an experienced DBA looking for an update on SQL capabilities.

 

sqladria

SQL Adria is the independent, non-profit organization that gathers relational database users for Croatia and Slovenia. It was founded 1994. and in the same year it has become the regional user group.

Follow us

facebook
linkid
twitter

 

Events in 2023

VODICE -  12th - 15th June 2023