I have a File which contains Funds only. Each Fund is say 3 Byte and new funds are incepted/ Old Funds are deleted periodically.
Every Quarter, we read a Tax File and split the Tax File
in to n no. of files assuming n funds present in the Fund File.We do this using sort but have to manually identify the Funds present in fund file and add Parms in the job if new Fund are incepted .
Lets consider an example :
At start of the Quarter we have AAA,BBB and CCC in fund file.
So we split the TAX file to TAX.AAA, TAX.BBB and TAX.CCC . This split is a simple INCLUDE COND=(1,3,CH,EQ,AAA) on the Tax file. Similar process followed for other Funds. And then we process the splitted Tax Files.
The issue is we have to add/remove steps in our job every quarter as the Fund file changes periodically. Is it possible that we automate the process whereby the Fund File is read and based on the no. of funds present in it, the tax File is split into seperate files ?
Say,if for the next quarter fund DDD is added, then the new process should be smart enough to identify this fund and create a new file TAX.DDD without manual interpretation ? (Currently we have to add a step in the job to achieve this).