Re: Copying a file from multiple sub-directories in the same parent to a DB2 file

Thanks Scott.
Not being familiar with QShell, how to I get the list back to my CL program
to process?

Thanks,



On Tue, Jan 24, 2012 at 1:08 PM, Scott Klement
<midrange-l@xxxxxxxxxxxxxxxx>wrote:

Hi Jeff,

You can locate all of the files in QShell like this:

find /MS_SQL -name 'External_File.txt'

This'll find all of the files in /MS_SQL (including any subdirectories
beneath it) that are named 'External_File.txt'. In a CL, you could loop
through that list and run CPYFRMxxxx and then RMVLNK.



On 1/24/2012 8:40 AM, Jeff Young wrote:

Hi Scott,
The file name will be the same in each subdirectory.
If the file exists, I want to copy it to a DB2 file.

ex: /MS_SQL/01
External_File.txt

/MS_SQL/021
External_File.txt

.
.
.
.
/MS_SQL/84
External_File.txt

I need to traverse each of the subdirectories in the MS_SQL directory and
if the file External_File.txt is present, copy it to a DB2 file then

delete

it.

Thanks,

On Mon, Jan 23, 2012 at 6:12 PM, Scott Klement
<midrange-l@xxxxxxxxxxxxxxxx>wrote:

Hi Jeff,

On 1/23/2012 4:23 PM, Jeff Young wrote:

This data will be coming from an external server.
Each subdirectly will represent data from a different country.
The client has decided that they want a separate folder for each

country.

Okay. So what will be in these "folders" (directories) for each country?
Is everything in the subdirectories a file to be processed? Or is
there a search criteria that needs to be used to determine if the file
is one to be processed?

I can create a loop to traverse each directory and use CPYTOSTMF to

copy

the data and remove the file with DEL after the copy, but I was hoping

for

a simple one line solution for the copy and for the delete.

You mean you want to run the READMYMIND command? (Or, the Unix
equivalent, ./readmymind)

--
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.

--
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.