RE: Find IFS files with part of filename

I'm not set on using SQL.

I'm here:
-PF of partial file names
-Large IFS folder of files

I need to get here:
-List of full file names

I don't want to install a new compiler, and i don't want to learn a whole new language just for this. Other than that I'm open to any solution.

Thanks


________________________________________
From: Scott Klement [midrange-l@xxxxxxxxxxxxxxxx]
Sent: Friday, October 27, 2017 4:58 PM
To: Midrange Systems Technical Discussion
Subject: Re: Find IFS files with part of filename

If it helps, I wrote some UDTFs that return the directory contents.
Then you don't have to create a temp file, you can just join to the
filename in the UDTF.

Though, I wonder if SQL is the right tool here to begin with? But,
maybe it is... depending on what you're doing.