Attending this event?
Wednesday, April 8 • 12:30pm - 1:45pm
SQL User Defined Table Functions (UDTF) – Hidden Secrets

Sign up or log in to save this to your schedule and see who's attending!

Data located within tables or physical files can be accessed, filtered and accumulated by executing a SQL SELECT statement. Creating and using SQL views instead of joining the tables and accumulating the data manually or within the source code helps to mask complexity and to reduce the source code. If the request can be fulfilled with a more or less complex SELECT statement, a view is the perfect tool. But if multiple statements must be performed for a single request, some type of program, either a stored procedure or a UDTF is needed. A User Defined Table Function (UDTF) is a program written either in SQL or a HLL (High Level Language such as RPG) that returns a table of data (x columns and y rows). A UDTF must be specified in the FROM clause of a SELECT statement. With external (written in a HLL) UDTF it is even possible to access non-database objects such as data areas, user spaces and IFS files and consume the data directly with SQL.

avatar for Birgitta Hauser

Birgitta Hauser

Fresche Solutions
Birgitta Hauser has been a Software and Database Engineer since 2008, focusing on RPG, SQL and Web development on IBM i at Toolmaker Advanced Efficiency GmbH in Germany.She graduated with a business economics diploma, and started programming on the AS/400 in 1992. She also works as... Read More →

Wednesday April 8, 2020 12:30pm - 1:45pm
(D) Commons I
Feedback form isn't open yet.

Attendees (2)