Find All Top-level Folders from a List of Folders #eg10

Problem description & analysis

We have a database table TBLFOLDERS as follows:

We are trying to find all top-level directories from it. Below is the desired result:

C:\Folder1

C:\Folder2\Subfolder1

Solution

We write the following SPL script p1.dfx within esProc:

Explanation:

A1   Connect to database mssql.

A2   Return a table sequence and auto-close the database connection when execution is finished.

A3  Find strings that are not contained in all the other strings.

Refer to How to Call an SPL SCript in Java to learn about how to integrate the SPL script with a Java program.
Q & A Collection

https://stackoverflow.com/questions/64125262/how-do-i-use-sql-to-select-only-top-level-folders-from-a-table-of-folders