Repeat read a file from starting after EOF using Selcopy

Ashish UK · New User Joined: 19 Jun 2011 Posts: 2 Location: UK

Hi,

My requirement is :
Read a file again from the first record although the EOF (End Of File) condition is encountered while reading the same file (using Selcopy only).

Please let me know at the earliest with the selcopy code.

Thanks,
Ashish

Bill Woodger · Posted: Sun Jun 19, 2011 12:10 pm

Have you tried anything? When, at EOF, you CLOSE the file then OPEN it, does it give you what you want? Obviously watch out for the 2nd EOF, you won't want to do it forever.

expat · Posted: Sun Jun 19, 2011 2:46 pm

dick scherrer · Posted: Mon Jun 20, 2011 9:42 am

Hello and welcome to the forum,

Why does someone believe the file needs to be "read again"?

As others have mentioned, we will help - but NOT simply do the work for you.

Ashish UK · New User Joined: 19 Jun 2011 Posts: 2 Location: UK

Hi,

Thanks for the reply. But it does not solve the problem. The requirement is :

01. To read File-A which is having the Duplicate records & those are sorted. I have to keep the duplicate records.
02. Read another file (say, File-B which is not having duplicate records) to get some extra information for all the records of File-A (including the Duplicate records).
03. I am getting the output till encounters a duplicate record from File-A. When ever Selcopy encounters a dupliacte key for the File-A, it is getting the next record from File-B. As a result there is mismatch of records.
04. So, if there is a duplicate record in File-A, then i have to read the File-B once again form Starting.

So, if any way i can reset the pointer value to first record of File-B, i can get all the values from File-B.

Please reply.

Bill Woodger · Posted: Mon Jun 20, 2011 12:12 pm

I think it is not SELCOPY that is doing this, but the stuff that you type in to SELCOPY. Program only do what you tell them, the thing is to tell them to do the right thing (and assuming that the solution you have chosen is possible).

You have A, sorted, with duplicates.

You have B, sorted(?), without duplicates.

Since you mention a "key" that "Selcopy encounters", I assume you are using some feature of Selcopy (feel free to let us know, otherwise we can shoot away in the dark).

If you are using such a feature, make sure you understand exactly what it is doing. This can also involve some simple tests with various combinations, multiples on first, second, both. Try to work out how the feature works.

I'd just suspect that if you swap the files around you might get the answer you want. But test it out first as I've suggested.

Dsingh29 · Active User Joined: 16 Dec 2008 Posts: 132 Location: IBM

Hey Ashish,

Your latest post is not in sync with your first one. Anyways, there is still lack of clarity on your requirements.

1. How are you reading file-B, is there any key to identify which records corresponds to file-A.
2. Why do you want to read file-B from starting in case of duplicates, simply hold the previous record (file-B) when next record (file-A) is same (mean duplicate).
3. Suggest you should search the forum for "file match algorithm", i think that is what your requirement is.

dick scherrer · Posted: Mon Jun 20, 2011 9:12 pm

Hello,