Re: Find IFS files with part of filename

[Scott Klement <midrange-l@xxxxxxxxxxxxxxxx>]

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.


On 10/27/2017 4:45 PM, Justin Taylor wrote:
> I have a PF that contains partial IFS filenames (ie. not the entire filename but only part of it).  I need to get the full file name. I know the QNTC folder where the files exist.
>
> My best thought so far is to use IFS APIs to iterate thru the folder and write all the filenames to a QTEMP table. Then it would be a simple matter of a SQL join. I just want to make sure I'm not overlooking a better solution.
>
> There will be about 200 partial filenames, and the folder contains about 80k files. This will be a recurring operation.
>
> Thx