Recursive SQL (OLAP processing) comes in handy when trying to create a Bill of Material (BOM) in a manufacturing environment as it allows for a "drill down" capability where you start with a finished product and drill into the assembly's detail until each individual component is known. This results in the complete Bill of Material.
But I used it in a previous life in an insurance company to drill into the history of policies to discover what coverage was in force at the time of a claim.
So it can have many applications.
With IBM's SQL OLAP support, writing these becomes pretty straight forward.
Steve Needles
-----Original Message-----
From: MIDRANGE-L [mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Hoteltravelfundotcom
Sent: Thursday, June 29, 2017 12:42 PM
To: Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxx>
Subject: Recursive SQL on the i
HI I was interested in how you might be using Recursive SQL on the i.
From what I have read on the IBM web site on this topic,. it seems most used in very large enormous, complex, data sets.
My way has always been to break the task into smaller manageable parts.
Perhaps someone who really knows can explain this better.
Thank you,
Joe
--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list To post a message email: MIDRANGE-L@xxxxxxxxxxxx To subscribe, unsubscribe, or change list options,
visit:
http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx Before posting, please take a moment to review the archives at
http://archive.midrange.com/midrange-l.
Please contact support@xxxxxxxxxxxx for any subscription related questions.
Help support midrange.com by shopping at amazon.com with our affiliate link:
http://amzn.to/2dEadiD
CONFIDENTIAL: The information contained in this email communication is confidential information intended only for the use of the addressee. Unauthorized use, disclosure or copying of this communication is strictly prohibited and may be unlawful. If you have received this communication in error, please notify us immediately by return email and destroy all copies of this communication, including all attachments.
midrange.com
