Steve Riedmueller sriedmue79
sriedmue79
/ CTE Example.sql
Last active
September 16, 2024 14:09
IBM i - Understanding CTEs and how to combine IBM i Services using LATERAL
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| -- | |
| -- Description: The "Common Table Expression" (CTE) is a very powerful and useful tool which allows a temporary "table" to be | |
| -- created in memory while a query is running. The contents of that temporary table (or "result set") can be | |
| -- referenced elsewhere in the query. | |
| -- | |
| -- The table functions provided by IBM as "IBM i Services" are ALSO very powerful. These functions allow us to | |
| -- use SQL to retrieve many different details from the system. This includes details about user profiles, | |
| -- network connections, objects, streamfiles, security, and much more. | |
| -- | |
| -- We can leverage CTEs to combine multiple IBM i Services table functions (and views) and make them even more |
OlderNewer