RE: Find IFS files with part of filename

The result tables are empty. I copied the path from an "ls", so I know it's correct. Does that command support QNTC?

Here's my command (I tried it with, and without, a trailing slash):
RTVDIRINF DIR('/qntc/.../My Folder') INFFILEPFX(XX) INFLIB(TSTDTA)



-----Original Message-----
From: Birgitta Hauser [mailto:Hauser@xxxxxxxxxxxxxxx]
Sent: Sunday, October 29, 2017 9:06 AM
To: 'Midrange Systems Technical Discussion' <midrange-l@xxxxxxxxxxxx>
Subject: RE: Find IFS files with part of filename

What do you want, you want to search the IFS to find a specific file?

What about the following solution:
1. Run the CL command RTVDIRINF.
RTVDIRINF will Return 2 Out Files beginning with the specified prefix (XXD and XXO) in the specified library:
RTVDIRINF DIR('/home/YourDirectory')
INFFILEPFX(XX)
INFLIB(YourLib)

2. Just join the 2 outfiles and search the result.
Something like this:
Select QEZDIRNAM1, qezobjnam
from YourLib.XXD join YourLib.XXO using(QEZDIRIDX) Where Upper(QEZDIRNAM1 concat QEZOBJNAM) like '%YOURFILE%';

Mit freundlichen Grüßen / Best regards

Birgitta Hauser

"Shoot for the moon, even if you miss, you'll land among the stars." (Les
Brown)
"If you think education is expensive, try ignorance." (Derek Bok) "What is worse than training your staff and losing them? Not training them and keeping them!"
"Train people well enough so they can leave, treat them well enough so they don't want to." (Richard Branson)