MVSFORUMS.com

[devpal]

Hi,


we are developing interfaces for transferring data through FTP. We need to transfer a VSAM master file everyday, which has got millions of records. The VSAM file has got no timesatmp or any date of creation of the record. WE have the date at which the record was last maintained. Currently our situation is that we have to transmit the entire file even if the changes have been made to only some records in it, because we do not have a timestamp to track the changed records in the existing system, while it would be sufficient to transmit ot transfer the changed records. Please can you provide me with any alternative solution? We thought of suing IEBCOMPR, but its a big file with about 80 fields and tracking the data would be difficult this way.


Regards,
DevPal.

[kolusu]

DevPal,

There are many ways to accomplish the task.

1. Repro the vsam cluster to a flat file( make it a GDG)

2. Compare the -1 gen to the current gen on the entire record length and capture all the Changed records to another flat file

3. FTP the output from step2.

Step 1 and 3 are self explanatory. For step2 , there are various utilities(DFSORT, EASYTRIEVE..) so on to compare 2 files.

Another alternative is to add a field at the end of the vsam cluster. So whenever a record is modified , the user need to update that field with an approriate value ( ex: A - for addition, D- for Delete , U - for update ...)

Now using this flag , you can extract the records to be FTP'ed

Hope this helps...

Cheers

Kolusu
_________________
Kolusu - DFSORT Development Team (IBM)
DFSORT is on the Web at:
www.ibm.com/storage/dfsort

www.linkedin.com/in/kolusu

[devpal]

Thank you very much Kolusu. Your solution provides the answer to my problem.