I have a distribution set up to query PDF load files for 200+ specific accounts.
My distribution writes the distribution to a file location (/odf/distribution/out) on AIX.
My load files typically contain many (typically hundreds of) statements and so my query may result in many statements meeting my distribution criteria and being put into a distribution file for a specific load file.
Out of the box ODF will create ONE distribution file and include in it every statement it finds that meets my distribution criteria in each load file. Ex. if 100 statements in the load file meet my criteria, ODF will put those 100 statements in a single file in the location I specify.
This is not the behavior that I want. I want ODF to create a separate PDF file for every statement that it finds that meet my distribution criteria. Ex. if 100 statements were found in my load file, I want ODF to create 100 individual PDF distribution files with 1 statement in each.
How do I configure ODF to do this without creating 100 distributions in ODF Administrator?