iSee Decimal Health Checker

User Defined Table Functions know to many of us as UDTFs.  These little beauties are often the backbone for a many of the SQL services that are published as views. For many, just using the View is great, provides a nice clean well formatted way to get at the data.  But once in a while we bump into an issue. Sometimes it’s a performance issue, maybe a data formatting issue, and having a way to get directly at the raw values and maybe get at them in a more focused manner. To help with this, we are going to show you how to see what is available, and how to use the UDTF interfaces that exist and are not documented.  This is your ‘un-official’ permission to make use of these where it makes sense.

Tim Rowe

Business Architect Application Development & Systems Management for IBM i

Tim Rowe is the Business Architect for IBM i responsible for System Management and Application Development. He has a passion for modernization on IBM i and how we can continue to move IBM i into the world of 'Normal' . In his spare time he is a certified Soccer referee and enjoys refereeing games with his youngest son.

Scott Forstie

Db2 for i Business Architect

Scott Forstie is a Senior Technical Staff Member within IBM i development and spends most of his time working as the Db2 for i Business Architect. He has worked on IBM operating system development since joining IBM in 1989.

Scott is a frequently published author, speaker at industry events around the globe and can be found @Forstie_IBMi and forstie@us.ibm.com. Scott is an avid runner and enjoys cooking.

Key:

Complete
Failed
Available
Locked
Video
Open to view video.
Open to view video.
You must register to access.
SQL Script
Open to download resource.
Open to download resource.
You must register to access.